Login and Permissions | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Login and Permissions

Hi there, I’d like to produce a list of all users with their permissions/system roles (dbowner, ddladmin, dbreader, dbwriter, etc.) Any system tables or sp_ procedures will allow me to do so? or any ways to achieve it? Secondly, how do I dertermine if user logins have not been used for a long time and can be removed from the system? Thanks.
SP_HELPROTECT to list the privileges. The best option is to run PROFILER or monitor the current activity and list out the used logins for certain period and drop the unused logins from the report.
Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.