DROP POLICY

A DDL command to remove a row level security policy from a table

DROP POLICY is a DDL command to remove a row level security policy from a table.

DROP POLICY was added in PostgreSQL 9.5.

Change history

Note that DROP POLICY has not actually been modified since it was introduced in PostgreSQL 9.5, where the ineffective CASCADE and RESTRICT syntax was also added (but not documented until PostgreSQL 9.6).

Categories

DDL, Security, SQL command

See also

CREATE POLICY, ALTER POLICY