REVOKE
Revokes privileges or role assignments
Available in
DSQL, ESQL
Syntax (revoking privileges)
REVOKE [GRANT OPTION FOR] <privileges>
FROM <grantee_list>
[{GRANTED BY | AS} [USER] grantor]
<privileges> ::=
!! See GRANT
syntax !!
Syntax (revoking roles)
REVOKE [ADMIN OPTION FOR] <role_granted_list> FROM <role_grantee_list> [{GRANTED BY | AS} [USER] grantor] <role_granted_list> ::= !! SeeGRANT
syntax !! <role_grantee_list> ::= !! SeeGRANT
syntax !!
Syntax (revoking all)
REVOKE ALL ON ALL FROM <grantee_list>
<grantee_list> ::=
!! See GRANT
syntax !!
Parameter | Description |
---|---|
grantor |
The grantor user on whose behalf the privilege(s) are being revoked |
The REVOKE
statement revokes privileges that were granted using the GRANT
statement from users, roles, and other database objects.See GRANT
for detailed descriptions of the various types of privileges.
Only the user who granted the privilege can revoke it.