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.