locked
SQL2005 permissions report RRS feed

  • Question

  • I have been asked by our auditors to provide them with a report of the the effective permissions by login on a specific database. They want to make sure that only certain individuals are allowed to execute stored procedures or update values in a table. Is there a standard report, or alternatively what code can I execute?
    Monday, November 23, 2009 10:41 AM

All replies

  • --You may use this function to find out the access level and privilges for a user on a particular database

    --But for each and every user , you may have to login with that user and run the below command

    USE

     

    databasename;

    SELECT

     

    *

    FROM

     

    fn_my_permissions('databasename', 'DATABASE');

    GO


    Thanks, Leks
    • Marked as answer by CJ_TSG Tuesday, November 24, 2009 10:09 AM
    • Unmarked as answer by CJ_TSG Tuesday, November 24, 2009 10:09 AM
    Monday, November 23, 2009 8:57 PM