SQL Server Performance Forum – Threads Archive
Login and PermissionsHi 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.
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.