sys.security_predicates (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 predicate in the database.
Column name | Data type | Description |
---|---|---|
object_id | int | ID of the security policy that contains this predicate. |
security_predicate_id | int | Predicate ID within this security policy. |
target_object_id | int | ID of the object on which the security predicate is bound. |
predicate_definition | nvarchar(max) | Fully qualified name of the function that will be used as a security predicate, including the arguments. Note that the schema.function name may be normalized (i.e. escaped) as well as any other element in the text for consistency. For example:[dbo].[fn_securitypredicate]([wing], [startTime], [endTime]) |
predicate_type | int | The type of predicate used by the security policy: 0 = FILTER PREDICATE 1 = BLOCK PREDICATE |
predicate_type_desc | nvarchar(60) | The type of predicate used by the security policy: FILTER BLOCK |
operation | int | The type of operation specified for the predicate: NULL = all applicable operations 1 = AFTER INSERT 2 = AFTER UPDATE 3 = BEFORE UPDATE 4 = BEFORE DELETE |
operation_desc | nvarchar(60) | The type of operation specified for the predicate: NULL AFTER INSERT AFTER UPDATE BEFORE UPDATE BEFORE DELETE |
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_policies (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