Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server 2016 (13.x) and later versions
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
SQL database in Microsoft Fabric
Returns a row for each security policy in the database.
| Column name | Data type | Description |
|---|---|---|
| name | sysname | Name of the security policy, unique within the database. |
| object_id | int | ID of the security policy. |
| principal_id | int | ID of the owner of the security policy, as registered to the database. NULL if the owner is determined via the schema. |
| schema_id | int | ID of the schema where the object resides. |
| parent_object_id | int | ID of the object to which the policy belongs. Must be 0. |
| type | vachar(2) | Must be SP. |
| type_desc | nvarchar(60) | SECURITY_POLICY. |
| create_date | datetime | UTC date the security policy was created. |
| modify_date | datetime | UTC date the security policy was last modified. |
| is_ms_shipped | bit | Always false. |
| is_enabled | bit | Security policy specification state: 0 = disabled 1 = enabled |
| is_not_for_replication | bit | Policy was created with the NOT FOR REPLICATION option. |
| uses_database_collation | bit | Uses the same collation as the database. |
| is_schemabinding_enabled | bit | Schemabinding state for the security policy: 0 or NULL = enabled 1 = disabled |
Permissions
Principals with the ALTER ANY SECURITY POLICY permission have access to all objects in this catalog view as well as anyone with VIEW DEFINITION on the object.