Database Administration (MOSC)

MOSC Banner

Private synonym not functioning - Insufficient privilege

edited Dec 28, 2010 6:03PM in Database Administration (MOSC) 8 commentsAnswered ✓
connected as ada_user2
select * from orders;
ORA-1031 insufficient privileges   But the select form ada_admin2.orders - brings data


SQL> select * from dba_synonyms where synonym_name='ORDERS'

OWNER                          SYNONYM_NAME                  
------------------------------ ------------------------------
TABLE_OWNER                    TABLE_NAME                    
------------------------------ ------------------------------
DB_LINK                                                                         
--------------------------------------------------------------------------------
ADA_USER                       ORDERS                        
ADA_ADMIN                      ORDERS                        
                                                                                
                                                                                
ADA_USER2                      ORDERS                        
ADA_ADMIN2                     ORDERS                        
                                                                                
                                                                                

2 rows selected.

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