The REVOKE statement revokes access privileges for a SQL/MX table, view, MV, schema, sequence generator, or stored procedure from specified users.
REVOKE [GRANT OPTION FOR]
{privilege [,privilege ]... | { ALL | ALL_DML | ALL_DDL } [PRIVILEGES]}
ON target
FROM grantee [,grantee ]... [drop-behavior ]
[BY authid-grantor]
grantee is:
authid | usernumber | PUBLIC
privilege is:
SELECT
| DELETE
| INSERT
| UPDATE [(column [,column ]...)]
| REFERENCES [(column [,column ]...)]
| USAGE
| EXECUTE
| CREATE
| ALTER
| DROP
grantee is:
authid | usernumber | PUBLIC | DB_PUBLIC
target is:
{ object-specification }
{ schema-specification }
object-specification is:
[ TABLE | SEQUENCE | PROCEDURE ]
object-name
schema-specification is:
{ SCHEMA schema-name }
drop-behavior is:
CASCADE | RESTRICT
|