What are different ways to find out the permissions granted to a particular user?

Last post 09-04-2008 5:08 PM by Adriaan. 1 replies.
Page 1 of 1 (2 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 09-04-2008 2:40 PM

    What are different ways to find out the permissions granted to a particular user?

    Besides using sp_helprotect, what are other system functions/system stored procedures/system tables/system views that I can use to find out granted permissions of a user?

    I have tried to trace sp_helprotect and it seems to me that I can use sys.database_permissions.

     

     

  • 09-04-2008 5:08 PM In reply to

    Re: What are different ways to find out the permissions granted to a particular user?

    There is of course the PERMISSIONS() function, which you can invoke only for the currently connected login, and for one object at a time. It gives you the effective permissions, although it won't tell you if a permission was denied - just that it was or was not granted. It covers column level permissions too. Check it out in BOL

Page 1 of 1 (2 items)
Active Topics   My Discussions    Unanswered Posts


© 2000 - 2007 vDerivatives Limited All Rights Reserved.