REVOKE SYSTEM PRIVILEGE
Revokes system privileges from one or more idents.
The specified system privilege is revoked from the ident(s) listed. If the privilege is revoked from a
GROUPident, all members of the group lose the privilege.
The system privileges are described under
GRANT SYSTEM PRIVILEGE.
GRANT OPTION FORclause specifies that only the
WITH GRANT OPTIONis to be revoked from the specified instance(s) of the privilege.
RESTRICTspecifies whether the
REVOKEstatement will allow recursive effects if the privilege was given with grant option. If
CASCADEis specified recursive effects will be allowed, else an error will be returned and the privilege is not revoked.
RESTRICTis specified, then
Privileges can only be revoked explicitly by the grantor.
If a system privilege has been granted to the same ident more than once (by different grantors), the
REVOKEstatement will only revoke (or will revoke the
WITH GRANT OPTIONfrom) the single instance of the privilege that was granted by the current ident.
The system rights attached to the privilege (or the
WITH GRANT OPTION) will only be revoked when the last instance of the privilege has been revoked.
Revoking system privileges has recursive effects on instances of the privilege being granted to other idents by virtue of the
When the last instance of a privilege
WITH GRANT OPTIONis revoked, all instances of the privilege granted by the ident under that authorization are recursively revoked.
Databanks, idents, shadows or schemas created while the privilege was held are not dropped when the privilege is revoked.
An ident may not revoke privileges from itself.
ExampleREVOKE DATABANK FROM joe, jane RESTRICT;
For more information, see the Mimer SQL User's Manual, Revoking System Privileges.
Mimer Information Technology AB
Voice: +46 18 780 92 00
Fax: +46 18 780 92 40