| title | sys.security_policies (Transact-SQL) | Microsoft Docs | ||||
|---|---|---|---|---|---|
| ms.custom |
|
||||
| ms.date | 06/10/2016 | ||||
| ms.prod | sql-non-specified | ||||
| ms.reviewer | |||||
| ms.suite | |||||
| ms.technology |
|
||||
| ms.tgt_pltfrm | |||||
| ms.topic | language-reference | ||||
| applies_to |
|
||||
| f1_keywords |
|
||||
| dev_langs |
|
||||
| helpviewer_keywords |
|
||||
| ms.assetid | 35362f5b-e601-4049-9e1d-c5307e823831 | ||||
| caps.latest.revision | 9 | ||||
| author | BYHAM | ||||
| ms.author | rickbyh | ||||
| manager | jhubbard |
[!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)