CREATE SESSION privilege is required for creation of any type of database link - Oracle

Q.  A database link is a pointer in the local database that lets you access objects on a remote database in order to create a private database link. Which privilege is required for creation of any type of database link?
- Published on 12 Aug 15

a. CREATE DATABASE LINK
b. CREATE PUBLIC DATABASE LINK
c. CREATE SESSION
d. Both A & B

ANSWER: CREATE SESSION

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 27 Aug 15
    - A database link is a pointer in the local database that lets you access objects on a remote database.

    - To create a private database link, you must have been granted the proper privileges.

    - The following are the types of privileges required by a database to perform the listed job:

    1. CREATE DATABASE LINK - It is used by the local database to create a private database link.

    2. CREATE PUBLIC DATABASE LINK - It is used by the local database to create a public database link.

    3. CREATE SESSION - It is used by the remote database to create any type of database link.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲