May 9, 2007 at 4:30 pm
Hi all,
how can i find all the users on server with their rights ?
Thanks
Paresh
May 9, 2007 at 4:44 pm
sp_helprotect is probably where you'll want to start.
May 10, 2007 at 7:07 am
What about sys.server_principals & sys.server_role_members? You can also go to each database and look at sys.database_principals and sys.database_role_members on each database.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
May 11, 2007 at 10:40 am
How about using "sp_helplogins"
------------
Prakash Sawant
http://psawant.blogspot.com
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply