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
6166 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

how to convert character strings to dates? : Sql dba

985

What do you think about pl/sql?

950

What is varray in pl sql?

1008

What are triggers in sql?

974

Why self join is used in sql?

919

how to show all tables with 'mysql'? : Sql dba

1060

how to convert dates to character strings? : Sql dba

1073

Is sql better than access?

965

What is data control language?

949

How do I create a sql database?

950

How to add a column ‘salary’ to a table employee_details?

955

Does pl/sql support create command?

1045

What can sql server reporting services do?

1058

where are cookies actually stored on the hard disk? : Sql dba

977

Why truncate is used in sql?

938