SQL Server Performance Forum – Threads Archive
Need Help on getting info about the loginsHi 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
SP_HELPROTECT and books online is your first help to search for more information. Satya SKJ
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.