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
- 6297 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
How many commands are in sql?
Does sap use sql?
How to add, remove, modify users using sql?
How do I run a sql query?
what are the differences between get and post methods in form submitting. Give the case where we can use get and we can use post methods? : Sql dba
What is pl sql collection?
What is scope of pl sql developer in future?
How many times can we commit in a loop?
How to add new employee details in an employee_details table with the following details
What are the benefits of triggers?
What are variables in pl sql?
Enlist some predefined exceptions?
What are pl/sql packages?
What is a variable in sql?
Does sql support programming?
