Updated on 2024-08-20 GMT+08:00

DROP AUDIT POLICY

Description

Deletes an audit policy.

Precautions

Only users with the POLADMIN or SYSADMIN permission, or the initial users can perform this operation.

Syntax

1
DROP AUDIT POLICY [IF EXISTS] policy_name;

Parameters

  • policy_name

    Specifies the audit policy name, which must be unique.

    Value range: a string. It must comply with the naming convention.

  • IF EXISTS

    Checks whether the audit policy exists. If it exists, the deletion is successful. Otherwise, a NOTICE message is sent.

Examples

-- Create the adt1 policy.
gaussdb=# CREATE AUDIT POLICY adt1 PRIVILEGES CREATE; 
CREATE AUDIT POLICY

-- Delete the audit policy adt1.
gaussdb=# DROP AUDIT POLICY adt1;
DROP AUDIT POLICY

-- When you delete the audit policy adt0 that does not exist, the system displays a message indicating that the deletion fails because the audit policy does not exist.
gaussdb=# DROP AUDIT POLICY adt0;
ERROR:  adt0 policy does not exist, drop failed