List users and permissions in a SQLSERVER2000

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • thegoogs

    List users and permissions in a SQLSERVER2000

    Hi, I have a question about users, logins and permissions in
    SQLServer2000.. .
    I have to list every user in a SQLServer, extract which database it can
    access and which permissions it has for every DB in that server....
    Is there a way to do that? Can I use a script in the "master" database?
    thanks.

Working...