Post reply

How to list object permissions for a role??

  • February 20, 2004 at 12:11 pm

    #86074

    In Enterprise Manager, I can look at all permissions granted to a particular role, broken out by user/object. To do this I double-click on the role, then choose "List only objects with permissions for this role"

    How do I do the same thing using SQL?

    Eagerly awaiting your expertise,

    Dana



    Dana
    Connecticut, USA
    Dana

  • February 20, 2004 at 7:18 pm

    #495029

    You want to take a look at the system stored procedure sp_helprotect.

     

    K. Brian Kelley
    @kbriankelley

  • February 23, 2004 at 12:08 pm

    #495200

    Perfect! Thank you!



    Dana
    Connecticut, USA
    Dana

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply