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
- 6481 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
Write a sql query to convert all character to uppercase after hypen.
What are keys in sql?
how to analyze tables with 'mysqlcheck'? : Sql dba
What is the most common sql injection tool?
How do you optimize a query?
How to add a column ‘salary’ to a table employee_details?
What is loop in pl sql?
what are the t string functions available in tsql? : Transact sql
What is interval partition?
What is the difference between delete, truncate and drop command?
What are the different operators available in sql?
differentiate between float and double. : Sql dba
What is the use of sqldataadapter?
What are the qualities of 2nf?
What is replication id?
