Table of Contents

Class SecuritySchema.SecurityPredicate

Namespace
LinqToDB.Tools.DataProvider.SqlServer.Schemas
Assembly
linq2db.Tools.dll

sys.security_predicates (Transact-SQL)

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.


See sys.security_predicates.

[Table(Schema = "sys", Name = "security_predicates", IsView = true)]
public class SecuritySchema.SecurityPredicate
Inheritance
SecuritySchema.SecurityPredicate
Inherited Members
Extension Methods

Properties

Object

objects (sys.objects)

[Association(ThisKey = "ObjectID", OtherKey = "ObjectID", CanBeNull = false)]
public ObjectSchema.Object Object { get; set; }

Property Value

ObjectSchema.Object

ObjectID

object_id NOT NULL int

ID of the security policy that contains this predicate. 
[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

Operation

operation NULL 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 
[Column("operation")]
[Nullable]
public int? Operation { get; set; }

Property Value

int?

OperationDesc

operation_desc NULL nvarchar(60)

The type of operation specified for the predicate:

NULL

AFTER INSERT

AFTER UPDATE

BEFORE UPDATE

BEFORE DELETE 
[Column("operation_desc")]
[Nullable]
public string? OperationDesc { get; set; }

Property Value

string

PredicateDefinition

predicate_definition NULL 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]) 
[Column("predicate_definition")]
[Nullable]
public string? PredicateDefinition { get; set; }

Property Value

string

PredicateType

predicate_type NULL int

The type of predicate used by the security policy:

0 = FILTER PREDICATE

1 = BLOCK PREDICATE 
[Column("predicate_type")]
[Nullable]
public int? PredicateType { get; set; }

Property Value

int?

PredicateTypeDesc

predicate_type_desc NULL nvarchar(60)

The type of predicate used by the security policy:

FILTER

BLOCK 
[Column("predicate_type_desc")]
[Nullable]
public string? PredicateTypeDesc { get; set; }

Property Value

string

SecurityPredicateID

security_predicate_id NOT NULL int

Predicate ID within this security policy. 
[Column("security_predicate_id")]
[NotNull]
public int SecurityPredicateID { get; set; }

Property Value

int

TargetObjectID

target_object_id NOT NULL int

ID of the object on which the security predicate is bound. 
[Column("target_object_id")]
[NotNull]
public int TargetObjectID { get; set; }

Property Value

int