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
6299 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 the syntax used for partition in tsql? : Transact sql

996

Why left join is used in sql?

958

What is sqlservr exe?

964

what is text? : Sql dba

1057

What is a dynamic query?

1007

What is the use of prepared statement?

995

Is pl sql a programming language?

963

Why select is used in sql?

1001

what is the bond code in materialized view?

2981

List and explain the different types of join clauses supported in ansi-standard sql?

1344

What is thread join () in threading?

996

explain commit and rollback in mysql : sql dba

993

how to enter binary numbers in sql statements? : Sql dba

952

How to call shell script from pl sql procedure?

1247

Can a foreign key have a different name?

932