DROP SECURITY POLICY (Transact-SQL)

Applies to: SQL Server 2016 (13.x) and later versions Azure SQL Database Azure SQL Managed Instance SQL analytics endpoint in Microsoft Fabric Warehouse in Microsoft Fabric

Deletes a security policy.

Transact-SQL syntax conventions

Syntax

DROP SECURITY POLICY [ IF EXISTS ] [schema_name. ] security_policy_name    
[;]  

Arguments

IF EXISTS

Applies to: SQL Server ( SQL Server 2016 (13.x) through current version).

Conditionally drops the security policy only if it already exists.

schema_name

Is the name of the schema to which the security policy belongs.

security_policy_name

The name of the security policy. Security policy names must comply with the rules for identifiers and must be unique within the database and to its schema.

Remarks

Permissions

Requires the ALTER ANY SECURITY POLICY permission and ALTER permission on the schema.

Examples

DROP SECURITY POLICY secPolicy;  

Related content

• Row-level security
• CREATE SECURITY POLICY (Transact-SQL)
• ALTER SECURITY POLICY (Transact-SQL)
• sys.security_policies (Transact-SQL)
• sys.security_predicates (Transact-SQL)