|
|
|
REVOKE GRANT OPTION did not remove column-level permissions. The following should remove the specified grant option from rootuser and remove all specified permissions that rootuser granted to others (child users), but still allow rootuser to access the table:
REVOKE GRANT OPTION FOR permission ON table FOR rootuser CASCADE
For table-level permissions this was done correctly. For column-level permissions, child users only had their grant option revoked rather than access permission.
The logic has been modified to correct this.
