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
6483 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 a control file ? : Sql dba

1084

what does myisamchk do? : Sql dba

1076

What is exit statement?

1057

Why we use pl sql?

1006

what are the features and advantages of object-oriented programming? : Sql dba

1070

What is the difference between inner join and natural join?

1051

List different type of expressions with the example.

966

what is sql profiler? : Sql dba

1113

Why is a primary key important?

1099

What is multiple partition?

1015

What is tuple in sql?

1138

define sql update statement ? : Sql dba

1157

What does (*) mean in sql?

995

Which function is used to return remainder in a division operator in sql?

1194

What is record data type?

974