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 √ Azure SQL Database √ Azure SQL Managed Instance √ Azure Synapse Analytics

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
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

ID of the security policy that contains this predicate.

[Column("object_id")]
[NotNull]
public int ObjectID { get; set; }

Property Value

int

Operation

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

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

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

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

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

Predicate ID within this security policy.

[Column("security_predicate_id")]
[NotNull]
public int SecurityPredicateID { get; set; }

Property Value

int

TargetObjectID

ID of the object on which the security predicate is bound.

[Column("target_object_id")]
[NotNull]
public int TargetObjectID { get; set; }

Property Value

int