Revoking Grant Authority - Firebird

To revoke a user’s grant authority for a given privilege, but keep the associated privilege, use REVOKE GRANT OPTION:

REVOKE GRANT OPTION FOR <privilege> [, <privilege> [,...]] ON <table> | <object> FROM <user> ;

For example, the following statement revokes grant authority for the SELECT privilege on DEPARTMENT from a user, HPOTTER, and he keeps his SELECT privilege:

REVOKE GRANT OPTION FOR SELECT ON DEPARTMENT FROM HPOTTER;

The execution of the statement will cascade down to any others users that have been granted grant authority by HPOTTER.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

Firebird Topics