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)
Phản hồi
https://aka.ms/ContentUserFeedback.
Sắp ra mắt: Trong năm 2024, chúng tôi sẽ dần gỡ bỏ Sự cố với GitHub dưới dạng cơ chế phản hồi cho nội dung và thay thế bằng hệ thống phản hồi mới. Để biết thêm thông tin, hãy xem:Gửi và xem ý kiến phản hồi dành cho