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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-10-06 : 07:44:36
|
| Bryan writes "I work on a database that was previously using SQL authentication. This backend db is also tied to a proprietary software product. Because of this proprietary software the SQL ids are still needed. I changed the in house application to use Windows Authentication; and to make this work I had to use Windows Security groups and add the user to our active directory. When I try to govern the users access in the in house application I need to pull their role from the database, i.e read-only, supervisor, etc. However, I can't pull the role back for the security groups. I've tried to use the system stored procedures to mimic the login process but had no luck.The way I figure the intitial login checks against our active diretory and verifies a user is part of a security group, so there has to be a way to check the role for that security group." |
|
|
|
|
|
SQL Server Login Process