Thursday 15 July 2010

sql server - List all the effective permissions (with users/roles) of a given object? -



sql server - List all the effective permissions (with users/roles) of a given object? -

how list users/roles granted permission(s) object, e.g. view, schema?

getuserrolepermissions 'dbo.aview' getuserrolepermissions 'aschema'

sql-server sql-server-2008

No comments:

Post a Comment