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 / meher

do login as sysdba and create the synonym.
you dont have privileges to do the same from scott user.

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are procedures used for?

521


Is sqlite free?

529


Is sql database free?

523


Explain what is rdbms?

578


What are the disadvantages of not performing database normalization?

589






Write a sql query to find the names of employees that begin with ‘a’?

568


State few characteristics of pl/sql?

555


What is the difference between join and natural join?

467


Is sql better than excel?

512


What is an emotional trigger?

509


What is error ora-01000: maximum open cursors exceeded

598


What is function and procedure?

558


What are the two types of cursors in pl sql?

530


What are tables and fields in the database?

547


What is the largest value that can be stored in a byte data field?

516