DROP PERMIT ON SEQUENCE
Valid in: SQL, ESQL, OpenAPI, ODBC, JDBC, .NET
The DROP PERMIT ON SEQUENCE statement removes permissions on sequences.
Permission: You must own a sequence to drop a permission on it.
This statement has the following format:
[EXEC SQL] DROP PERMIT ON SEQUENCE ALL | seq_name seq_list;
If the keyword ALL is used, Ingres removes all permissions defined on the specified sequence. To remove individual permissions, use the sequence name and list.
To obtain the sequence values associated with specific permissions, use the HELP PERMIT statement.
Note: Permits cannot be dropped if there are dependent objects or permits. In this case, REVOKE...CASCADE must be used.
In an embedded statement, no portion of the syntax can be replaced with host language variables.
The statement takes an exclusive lock on the base table and on pages in the iipermits system catalog.
Last modified date: 08/29/2024