Roles and permissions

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.

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" wrote in message

>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.
>
>