vpruthi/doc-exports
1
0
Fork 0
forked from docs/doc-exports
Code Pull Requests Activity
doc-exports/docs/dws/dev/dws_06_0200.html
Lu, Huayi a24ca60074 DWS DEVELOPER 811 version 
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Lu, Huayi <luhuayi@huawei.com>
Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
2023-01-19 13:37:49 +00:00

4.7 KiB
Raw Permalink Blame History

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

1
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 a row-level access control policy to be deleted.
    • table_name

      Specifies the name of a table to which a row-level access control policy is applied.

    • CASCADE/RESTRICT

      The two parameters are used only for syntax compatibility. No objects depend on access control policies and thereby CASCADE is equivalent to RESTRICT.

Examples

Delete the row-level access control policy.

DROP ROW LEVEL SECURITY POLICY all_data_rls ON all_data;

Helpful Links

ALTER ROW LEVEL SECURITY POLICY, CREATE ROW LEVEL SECURITY POLICY

Parent topic: DDL Syntax