Is
there a way to find a list of Windows User accounts that are directly
or indirectly (through Windows Group membership) assigned to a database
role
I could put work in to CLR programming or using a Linked Server to
Active Directory, but if there is a sys.* view available that can
provide me this
information directly it would be much easier.
I'll be looking into this further myself anyway and posting an answer
if I can find one, but if anyone has suggestions... well, thanks!
Accessing Windows Users assigned to a database role
Hot Topic
- Buffer Exception
- Clarifications on Queue Service and Queue Readers
- report authentication: windows prompt removal
- How to make an if in the dataflow ?
- Moving SSIS packages from one machine to the other
- Is this possible? How
- Derived Shape - Replacing a column with itself.
- connection string & location problems
- Studio 2005 Sql environment?
- Matrix Column Trouble
SQL Server
- Store images in db or in file system.
- Database on server but SQLEXPRESS on local machine
- Deployed reports have javascript errors?
- cant connect
- Strings, Splitting, and Numerics
- Catch Error message in Variable?
- OLE DB error - TCP Provider: No connection could be made because the target machine actively refused it.
- DB Maint Plan - Cleanup old DB Backup files not working
- LIMIT Clause
- "could not open connection to SQL Server"?
Accessing Windows Users assigned to a database role
prinso
Hi,
guess not, but if you have one ready, feel free to post it to me, I will bring it online on my soon launched site www.sqlserver2005.de
HTH, jens Suessmeyer.