Enterprise Manager Generic (MOSC)

MOSC Banner

How to access a SYSTEM owned custom table through EM - Configuration Extension

edited Oct 9, 2014 10:01AM in Enterprise Manager Generic (MOSC) 2 commentsAnswered

Hi,

I am writing a custom configuration extension and using the following SQL, table "mysession_log" is custom table owned by SYSTEM. After associating the targets getting the error "Failed to execute query. Cause-Failed to prepare sql query. ORA-01031: insufficient privileges (DBD ERROR: error possibly near <*> indicator at char 28 in 'select username from system.<*>mysession_log')"

select username from SYSTEM.mysession_log

I am not sure what is the issue here, I logged into the DB using SYSMAN account and can able to query the table. So is it really a permission issue or else we can't access custom SYSTEM owned tables using EM?

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