Ingres 11.0 | Drop Permit Statement

SQL Reference Guide > SQL Reference Guide > B. SQL Statements from Earlier Releases > Drop Permit Statement

Was this helpful?

Drop Permit Statement

Permission: You must own a table, view, database event, or procedure to drop a permission on it.

The Drop Permit statement removes permissions on tables, views, database events, and procedures.

This statement has the following format:

For tables and views:

[EXEC SQL] DROP PERMIT ON table_name

ALL | integer {, integer};

For procedures:

[EXEC SQL] DROP PERMIT ON PROCEDURE proc_name

ALL | integer {, integer};

For events:

[EXEC SQL] DROP PERMIT ON DBEVENT event_name

ALL | integer {, integer};

If the keyword ALL is used, Ingres removes all permissions defined on the specified table, view, database event, or procedure. To remove individual permissions, use the integer list. To obtain the integer values associated with specific permissions, use the HELP PERMIT statement.

Note: Permits cannot be dropped if there are dependent objects (views or database procedures) or permits. In this case, REVOKE...CASCADE must be used.

Last modified date: 01/30/2023