Need Help on getting info about the logins | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Need Help on getting info about the logins

Hi Is there any way (sp?) to extract the roles/privileges for the all users/logins in all the databases? If any one has script, please let me share. I am new to SQL SERVER stored procedures. I need to extract the information for audit purposes from few of my MS-SQL databases. Your help highly appreciated. Thanks In Advance. Regards
Nagesh
Nagesh
SP_HELPROTECT and books online is your first help to search for more information. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>