sys-security-predicates-transact-sql.md

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
sys.security_predicates (Transact-SQL)	sys.security_predicates (Transact-SQL)	VanMSFT	vanto	06/10/2016	sql	system-objects	reference	SYS.SECURITY_PREDICATES SECURITY_PREDICATES SECURITY_PREDICATES_TSQL SYS.SECURITY_PREDICATES_TSQL	sys.security_predicates catalog view security_predicates catalog view	TSQL	=azuresqldb-current||>=sql-server-2016||=azure-sqldw-latest||>=sql-server-linux-2017||=azuresqldb-mi-current

sys.security_predicates (Transact-SQL)

[!INCLUDE sqlserver2016-asdb-asdbmi-asa]

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)