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. RegardsNagesh
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.
]]>