You find this information in sys.database_permissions. You find all permissions related to the table from rows that have major_id = object_id('yourtable'). If there are rows with non-zero value in minor_id, they are permissions on colunm level.
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
No comments:
Post a Comment