Permissions on a table (direct & indirect)

  • Is there a script to retrieve permissions granted on a single table through all the logins, users, roles, etc.,

    For example, dbo.Users table is queried through a view dbo.v_users and if permissions were given to dbo.v_users to read and say write permissions were given on the table through a stored procedure to a different user. How do I get a list of all permissions granted directly or indirectly to the table dbo.Users?

Viewing 0 posts

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