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.
- 3 Answers
- 5551 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
What type of database is sql?
What is difference between table and view?
What is PL/SQL Records?
Where is pl sql used?
What is the difference between sql and isql*plus?
What are all the different normalizations?
How can one get sql*loader to commit only at the end of the load file? : aql loader
Is nosql relational?
What are the query optimization techniques?
Can one improve the performance of sql*loader? : aql loader
What is the usage of when clause in trigger?
What is sql scripting?
What will you get by the cursor attribute sql%found?
what is the difference between truncate and delete statement? : Transact sql
What is the benefit of foreign key?
