Database Security Products (MOSC)

MOSC Banner

ORA-01031 and compile public synonym object

edited May 31, 2010 10:05PM in Database Security Products (MOSC) 4 commentsAnswered
 Hy,

I get ORA-01031 when I try to compile a public synonym object :

alter public SYNONYM PT1XXXX compile;
*
ERREUR Á la ligne 1 :
ORA-01031: privilÒges insuffisants

(I have DBA role  and I am the PT1XXXX object's owner)

But when when I try to compile

with sqlplus / as sysdba  It's OK :

 alter public SYNONYM PT1XXXXcompile;

Synonyme modifiÕ. 

Who can help me ?

Regards

ERIC

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