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.
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
What is ttitle and btitle?
Is nosql faster than sql?
Does sqlite need a server?
What is the order of sql select?
What are all the different types of indexes?
what are properties of a transaction? : Sql dba
how to create a test table in your mysql server? : Sql dba
How does stored procedure reduce network traffic?
What can sql server reporting services do?
What are the different types of database management systems?
What is count * in sql?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is join view in sql?
What is the usage of when clause in trigger?
What will you get by the cursor attribute sql%notfound?