DROP CAPTURE PRIVILEGES POLICY v16

EDB Postgres Advanced Server includes syntax not offered by Oracle with the DROP CAPTURE PRIVILEGES POLICY SQL command.

Name

DROP CAPTURE PRIVILEGES POLICY — Drop an existing capture privilege policy.

Use DROP CAPTURE PRIVILEGES POLICY to drop an existing policy to capture privileges:

DROP CAPTURE PRIVILEGES POLICY [ IF EXISTS ] <name> [ CASCADE | RESTRICT ]

DROP CAPTURE PRIVILEGES POLICY allows a superuser or a user with the CREATE_CAPTURE privilege to drop an existing queue.

name

The name optionally schema-qualified of the capture privilege policy that's being dropped.

This example drops a capture privilege policy named sampledb_p2:

DROP CAPTURE PRIVILEGES POLICY sampledb_p2;