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
define data blocks ? : Sql dba
How do I view an execution plan in sql?
Explain clause in sql?
What are different methods to trace the pl/sql code?
Difference between truncate, delete and drop commands?
What is trigger in sql and its types?
Can we use the cursor's to create the collection in PL/SQL?
How does stored procedure reduce network traffic?
What is inner join in sql?
What is latest version of sql?
Is vs as in pl sql?
What is indexing in sql and its types?
Why is nosql good?
how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba
What is the process of copying data from table a to table b?