locked
SP to get users and their permissions RRS feed

  • Question

  • Is there an SP that can tell the database, the users with access to the database, and their permissions?  Meaning the result would be something like...
    <database>     <username>     db_datawriter
    <database>     <username>     db_datareader
    <database>     <usernameII>   db_owner

    Thanks in advance
    -Kyle
    Friday, September 7, 2007 8:20 PM

Answers

  • sp_helplogins is the answer.
    -Kyle
    Wednesday, September 12, 2007 12:59 PM

All replies

  • You can take a look sp_helprotect and fn_my_permissions (sql2k5) in book online.

    Saturday, September 8, 2007 11:43 PM
  • sp_helplogins is the answer.
    -Kyle
    Wednesday, September 12, 2007 12:59 PM