Thanks so much!sp_helpuser will list all the users.
sp_helplogins gives all the login users.
these procedures might help you
Showing posts with label rights. Show all posts
Showing posts with label rights. Show all posts
Monday, March 12, 2012
List of users and user rights
Does anyone have a query that will list all the users and user rights for a sqlserver database.
List of users + roles + rights
How can I generate a list/view of all users/groups with appropriate roles and rigths?SP_HELPROTECT list all the information in the database.|||Hi,
Can someone please let me know if there is some way to find out the roles of a user in SQL server 2000?
The sysusers table has a column called roles that stores a bit set for every role associated with the user. But given a user name / uid how to find out all the roles (role ids will do) associated with that user?
Please help ... its urgent.
Thanks for your time,
Sayali|||In SQL-2000, this is stored in sysmembers (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-m_6f3n.asp).
-PatP
Can someone please let me know if there is some way to find out the roles of a user in SQL server 2000?
The sysusers table has a column called roles that stores a bit set for every role associated with the user. But given a user name / uid how to find out all the roles (role ids will do) associated with that user?
Please help ... its urgent.
Thanks for your time,
Sayali|||In SQL-2000, this is stored in sysmembers (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sys-m_6f3n.asp).
-PatP
Subscribe to:
Posts (Atom)