SQL Language (MOSC)

MOSC Banner

12.1.0.2 : select from table results in 01031: insufficient privileges

edited Jan 20, 2019 4:04AM in SQL Language (MOSC) 4 commentsAnswered

Hello,

We have a  EBS R12.2.8 database  .  The db version is 12.1.0.2.     Selecting from one of the table results in  "01031: insufficient privileges" error.  I am trying to query this from  same schema as the table owner.   Other tables in this schema does not have this issue but only this table.   The table has around 450000 records.

select count(*) from  wip_discrete_jobs;

ORA-01031: insufficient privileges

I have connected to same schema as the table owner. 

There are no error in  alert.log and   I checked for block corruption and did not find any block corrupt.  

Please advise.

Thanks

Ram

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