Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6361 Views
- I also Faced
- E-Mail Answers
Answer Posted / sanjaya
STEP 1:
-------
OPEN SQL*PLUS
LOGIN AS
USER: SYSTEM
PASSWORD: ********
STEP 2:
-------
SQL> GRANT OLAP_USER TO SCOTT;
STEP 3:
-------
SQL> CONNECT
Enter user-name: SCOTT
Enter password: *****
STEP 4:
-------
SQL> CREATE [PUBLIC] SYNONYM <SYN_NAME>
FOR <USER_NAME.ABLE_NAME>;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain how you can copy a file to file content and file to pl/sql table in advance pl/sql?
is it possible to pass an object or table to a procedure as an argument?
Explain the purpose of %type and %rowtype data types?
How to use boolean type in select statement?
What are all different types of collation sensitivity?
Explain clause in sql?
What is difference between left and right outer join?
How do you pronounce sql?
Name the operator which is used in the query for pattern matching?
What is primary key in db?
Does execute immediate commit?
What is the difference between rename and alias?
What is sql server and ase?
Why is there a need for sqlcode and sqlerrm variables?
Why plvtab is considered as the easiest way to access the pl/sql table?
