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
Mr555 - 31 Jul 2008 05:47 GMT
sorted
Use Database1
EXEC sp_helpuser
> Hello everyone
>
[quoted text clipped - 7 lines]
>
> Thanks