I administer a small datawarehouse in Oracle. My user dwhmanager was given the SELECT ANY TABLE privilege:
GRANT SELECT ANY TABLE TO dwhmanager WITH ADMIN OPTION;
The idea was to have the ability to grant access to tables in several schemas to the developers in the datawarehouse.
Example:
GRANT SELECT ON DWHFINANCE.SALES TO johndeveloper;
However, I found my self getting the infamous ORA-01031: insufficient privileges
I can however, give "johndeveloper" the SELECT ANY TABLE privilege as well, and from that, he could select on any table on the datawarehouse, however, that's too much, not my intend.
So, what permission to I need to ask to the main DBA to grant me in order to have the power to give permissions in individual tables in other schemas?