11.8.4 Revoking only the grant options for access privileges that were granted to HADB users
To revoke only the grant options for access privileges that were granted to HADB users, execute the REVOKE statement with GRANT OPTION FOR specified.
- Important
-
Only HADB users who have been granted access privileges with the grant options can revoke those grant options for access privileges.
The following example explains how to revoke only the grant options for access privileges that were granted to HADB users.
- Example:
-
In this example, only the grant option for the SELECT privilege for table A.T1 that was granted to HADB user ADBUSER01 is revoked.
REVOKE GRANT OPTION FOR SELECT ON "A"."T1" FROM "ADBUSER01"
To revoke only the grant option, execute the REVOKE statement with GRANT OPTION FOR specified.
In this case, the SELECT privilege for table A.T1 that was granted to HADB user ADBUSER01 is not revoked.
For details about the REVOKE statement, see REVOKE (revoke privileges) in Definition SQL in the manual HADB SQL Reference.
- Important
-
-
If the grant option for a privilege is revoked, all access privileges that were granted by using that grant option are revoked. For details, see (4) Revoking access privileges in 2.7.5 Access privileges.
-
If the grant option for the SELECT privilege is revoked, all SELECT privileges that were granted by using that grant option are also revoked. This might cause the relevant viewed tables to be invalidated. For details, see 2.7.6 Access privileges for viewed tables.
-