Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2002
    Location
    Belgium
    Posts
    43

    Angry Unanswered: SQL7 List of users/rights on tables-views-SP

    Greetings!

    I'm looking for a trick by which I could extract a COMPLETE LIST
    of ALL USERS and their rights (INSERT/DELETE/EXECUTE etc.) on
    ALL OBJECTS such as tables, views and stored procedures in MSSQL 7.

    Via sp_table_privileges I managed to extract all relevant rights for every
    user on all tables in a specific database.
    However this SP does not extract the same data concerning views and/or
    stored procedures in the same database.

    Maybe I didn't look in the right places.
    Anyuseful tip / trick to extract this (in table-format) is welcome.

    Thanks a lot!

    VincentJS
    Gent, Belgium

  2. #2
    Join Date
    Jul 2002
    Location
    Village, MD
    Posts
    621
    Check table sysprotects. See details in BOL.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •