Re: Roles and permissions
- From: Munish Narula <munish.narula@xxxxxxxxx>
- Date: Wed, 3 Dec 2008 21:12:00 -0800
Thanks Russell.
"Russell Fields" wrote:
Munish,.
For SQL Server 2000, here is a start.
To see all logins and their group memberships on a server, run:
exec sp_helplogins
Within a database you can also run:
exec sp_helprolemember
For each database, to see all rights granted in that database run:
exec sp_helprotect
You can also look at the code of these stored procedures to see the tables
that they use.
RLF
"Munish Narula" <munish.narula@xxxxxxxxx> wrote in message
news:E5E0E381-64BF-418E-AD6D-0BA3C1FBB4CA@xxxxxxxxxxxxxxxx
I need to get all roles, users and their permissions in SQL 2000. Please
let
me know how can i get those.
Which table returns me the roles existing in the database and the
permission
assigned to these roles in SQL 2000.
Also which table would give me the relation between the role and the users
in that role in SQL 2000.
- References:
- Roles and permissions
- From: Munish Narula
- Re: Roles and permissions
- From: Russell Fields
- Roles and permissions
- Prev by Date: SSL Connections and Dynamic Management Views
- Next by Date: Re: SSL Connections and Dynamic Management Views
- Previous by thread: Re: Roles and permissions
- Next by thread: SSL Connections and Dynamic Management Views
- Index(es):
Relevant Pages
|
