Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
DavidMcD
Starting Member
3 Posts |
 Posted - 2005-07-01 : 18:09:18
|
| I have an application that uses sp_HelpUser with a parameter calculated from suser_sname() to determine the SQL Server roles that the current user in. I then implement "front end security" by disabling and enabling buttons depending upon their roles.This works fine when the users (in this case derived from NT users) are explicitly added. However, I wish to base all users for the database on NT groups.When all SQL users are based on NT groups and sp_HelpUser is run for the current user, the function returns,"The name supplied (DOMAIN_Name\User_Name) is not a user, role, or aliased login." This of course makes sense because DOMAIN_Name\User_Name is no longer a user, but is a member of a NT group that is.How can I return the roles for the current user, without explicitly creating the SQL user?Thanks,David |
|
|
|
|
|
sp_HelpUser