Details
-
Bug
-
Status: Closed
-
Major
-
Resolution: Fixed
-
None
-
None
-
None
Description
dbroot:
SQL> grant select(a), delete,insert(a), update(a) on t1 to user2 with grant option;
— SQL operation complete.
User2:
qi_mxci2> set schema my_sec_test;
— SQL operation complete.
qi_mxci2> grant select(a), delete on t1 to user5;
— SQL operation complete.
qi_mxci2> grant select(b) on t1 to user5;
— SQL operation complete.
user2 doesn’t have select privilege on column b but can grant the privilege to other user. It should get ERROR[4481] here.