ORA-25433: User Does Not Have INHERIT REMOTE PRIVILEGES Privilege On Connected User
reviewing Oracle note, I found that I needed to give " INHERIT REMOTE PRIVILEGES " to the user.
GRANT EXECUTE ON PHXPROD.PKG_ROK_DATA_LOAD_2 TO PPHILLIP; (user already had this privs)
GRANT INHERIT REMOTE PRIVILEGES ON USER PPHILLIP TO PHXPROD;(granted this privilege)
Question: which oracle table should I query to figure out which all users have the similar privilege, i.e. INHERIT REMOTE PRIVILEGES, etc. in this database. d
I queried several tables that had column name like INHERIT but it did not help.
Thank you
Jack