printout of effective access rights for all users and grou..

Hello everyone

Within each database there is an icon called users, within that user
containner , you can see users has different permission for that database.
Is it possible to display a list of effective access rights for all users
and groups for a particular DB in SQL2000, I want to be able to print out a
list of those users amd permision

I am new to SQL any help will be really appreciate it

Thanks

sorted
Use Database1
EXEC sp_helpuser

"Mr555" wrote:

> Hello everyone
>
> Within each database there is an icon called users, within that user
> containner , you can see users has different permission for that database.
> Is it possible to display a list of effective access rights for all users
> and groups for a particular DB in SQL2000, I want to be able to print out a
> list of those users amd permision
>
> I am new to SQL any help will be really appreciate it
>
> Thanks