We help IT Professionals succeed at work.
Get Started

Oracle synonym behavior

Oranew asked
Last Modified: 2015-03-10
I have granted the alter privileges to a a user on a table but can not able to alter it without owner.table_name. The synonyms are already created and he can able to select it. Here are the steps. Can you please point out what is missing here?

SQLPLUS>show user
SQLPLUS>desc ps_test_1
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 A                                                  NUMBER
 FF                                                 VARCHAR2(20)

SQLPLUS>select * from ps_test_1;

         A FF
---------- --------------------

SQLPLUS>alter table ps_test_1 add xyz varchar2(20);
alter table ps_test_1 add xyz varchar2(20)
ERROR at line 1:
ORA-00942: table or view does not exist

SQLPLUS>alter table sysadm.ps_test_1 add xyz varchar2(20);

Table altered.

The table is getting altered when using the <OWNER.TABLE_NAME > but not just with the table name. I can select it and the public synonym is there on this table.
Experts , What is missing here ?
Watch Question
Senior Database Administrator
This problem has been solved!
Unlock 1 Answer and 1 Comment.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE