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.
Synopsis
Use DROP CAPTURE PRIVILEGES POLICY to drop an existing policy to capture privileges:
DROP CAPTURE PRIVILEGES POLICY [ IF EXISTS ] <name> [ CASCADE | RESTRICT ]
Description
DROP CAPTURE PRIVILEGES POLICY allows a superuser or a user with the CREATE_CAPTURE privilege to drop an existing queue.
Parameters
name
The name optionally schema-qualified of the capture privilege policy that's being dropped.
Examples
This example drops a capture privilege policy named sampledb_p2:
DROP CAPTURE PRIVILEGES POLICY sampledb_p2;
See also
CREATE CAPTURE PRIVILEGE POLICY, ALTER CAPTURE PRIVILEGE POLICY