Removes specific system privileges from specific users and the right to administer the privilege.
REVOKE [ ADMIN OPTION FOR ] <system_privilege_name> [,...] FROM <userID> [,...]
REVOKE BACKUP DATABASE FROM Jim
REVOKE ADMIN OPTION FOR BACKUP DATABASE FROM Jim
Depending on how the system privilege was initially granted, using the ADMIN OPTION FOR clause when revoking a system privilege has different results. If you the system privilege was originally granted with the WITH ADMIN OPTION clause, including the ADMIN OPTION FOR clause in the revoke statement revokes only the ability to administer the system privilege (that is, grant the system privilege to another user). The ability to actually use the system privilege remains. However, if the system privilege was originally granted with the WITH ADMIN ONLY OPTION clause, including the ADMIN OPTION FOR clause in the revoke statement is semantically equivalent to revoking the entire system privilege. Finally, if the system privilege was originally grant with the WITH NO ADMIN OPTION clause, and the ADMIN OPTION FOR clause is included in the revoke statement, nothing is revoked because there were no administrative system privileges granted in the first place.
SQL–other syntaxes are vendor extensions to ISO/ANSI SQL grammar.
SAP Database products–syntax is not supported by SAP ASE.