Database - RAC/Scalability (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center