Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register todayThis browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Applies to: SQL Server 2016 (13.x) and later versions Azure SQL Database Azure SQL Managed Instance Azure Synapse Analytics SQL database in Microsoft Fabric
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 |
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_policies (Transact-SQL)
CREATE SECURITY POLICY (Transact-SQL)
Security Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)
Principals (Database Engine)
Events
Mar 31, 11 PM - Apr 2, 11 PM
The ultimate SQL, Power BI, Fabric, and AI community-led event. March 31 - April 2. Use code MSCUST for a $150 discount. Prices go up Feb 11th.
Register today