sys.security_policies (Transact-SQL)

Applies to: SQL Server 2016 (13.x) and later Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics

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.

See Also

Row-Level Security
sys.security_predicates (Transact-SQL)
CREATE SECURITY POLICY (Transact-SQL)
Security Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
Principals (Database Engine)