Help Center/ GaussDB/ Developer Guide(Centralized_2.x)/ SQL Reference/ SQL Syntax/ DROP ROW LEVEL SECURITY POLICY
Updated on 2023-10-23 GMT+08:00
View PDF
Share

DROP ROW LEVEL SECURITY POLICY

Function

DROP ROW LEVEL SECURITY POLICY deletes a row-level access control policy from a table.

Precautions

Only the table owner or administrators can delete a row-level access control policy from the table.

Syntax

DROP [ ROW LEVEL SECURITY ] POLICY [ IF EXISTS ] policy_name ON table_name [ CASCADE | RESTRICT ]

Parameter Description

  • IF EXISTS

    Reports a notice instead of an error if the specified row-level access control policy does not exist.

  • policy_name
    Specifies the name of the row-level access control policy to be deleted.
    • table_name

      Specifies the name of the table containing the row-level access control policy.

    • CASCADE/RESTRICT

      Currently, no objects depend on row-level access control policies. Therefore, CASCADE is equivalent to RESTRICT, and they are reserved to ensure backward compatibility.

Examples

-- Create the data table all_data.
openGauss=# CREATE TABLE all_data(id int, role varchar(100), data varchar(100));

-- Create a row-level access control policy.
openGauss=# CREATE ROW LEVEL SECURITY POLICY all_data_rls ON all_data USING(role = CURRENT_USER);

-- Delete a row-level access control policy.
openGauss=# DROP ROW LEVEL SECURITY POLICY all_data_rls ON all_data;

Helpful Links

ALTER ROW LEVEL SECURITY POLICY and CREATE ROW LEVEL SECURITY POLICY

Parent topic: SQL Syntax