title: "sys.security_policies (Transact-SQL) | Microsoft Docs" ms.custom: "" ms.date: "06/10/2016" ms.prod: sql ms.prod_service: "database-engine, sql-database" ms.component: "system-catalog-views" ms.reviewer: "" ms.suite: "sql" ms.technology: system-objects ms.tgt_pltfrm: "" ms.topic: "language-reference" applies_to:
- "Azure SQL Database"
- "SQL Server 2016 Preview" f1_keywords:
- "SYS.SECURITY_POLICIES_TSQL"
- "SECURITY_POLICIES_TSQL"
- "SYS.SECURITY_POLICIES"
- "SECURITY_POLICIES" dev_langs:
- "TSQL" helpviewer_keywords:
- "sys.security_policies catalog view"
- "security_policies catalog view" ms.assetid: 35362f5b-e601-4049-9e1d-c5307e823831 caps.latest.revision: 9 author: edmacauley ms.author: edmaca manager: craigg monikerRange: "= azuresqldb-current || >= sql-server-2016 || = sqlallproducts-allversions"
[!INCLUDEtsql-appliesto-ss2016-asdb-xxxx-xxx-md]
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 |
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.
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)