Hi,
I have a user user_1 with "create any table" & select any table with admin
option".

However, when user_1 tries to grant select table privileges to a table
another schema to a user, it
give me an error of insufficient privileges.


SQL > grant select on user_2.test_table to web_read_usr ;
ERROR at line 1:
ORA-01031: insufficient privileges

I tried granting "grant any privilege" to user_1 but that didn't make
difference.

What system privilege I should give to user_1 to make my mission successful?

Thanks,
Ancy

Oracle LazyDBA home page