login as the user create or replace synonym <<synonym

I want to create synonym for table emp but in my pc it is
giving insufficient previliges.I am using user scott.Please
suggest me.

Question Posted / sreekumar

3 Answers
6344 Views
I also Faced
E-Mail Answers

Answer Posted / sreekumar

login as the user
create or replace synonym <<synonym_name>> for
object_owner.object_name;
or
any other super user like sys,sysadmin,etc can also create
sysnonymn for any schema.

Thanks
Sree
Oracle10g DBA

Is This Answer Correct ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is having clause in sql?

966

Where not exists in sql?

980

What are the advantages of sql?

1055

What are all the different normalization?

1038

Can we use delete in merge statement?

1039

what is the difference between truncate and drop statements? : Sql dba

1126

what are date and time data types? : Sql dba

984

Explain autonomous transaction.

1157

how to escape special characters in sql statements? : Sql dba

1036

What are the parameter modes supported by pl/sql?

1109

What is trigger in sql?

1101

How does an execution block start and end in pl sql?

951

How are sql commands classified?

1089

What is sql profiling in oracle?

1065

What is sql data?

996