Connected user link type of link users connect as themselves - Oracle Distributed Database concepts

Q.  In ________ type of link users connect as themselves. This means that they must have an account on the remote database with the same username as their account on the local database.
- Published on 13 Aug 15

a. Connected user link
b. Fixed user link
c. Current user link
d. Both A & B

ANSWER: Connected user link
 

    Discussion

  • Nirja Shah   -Posted on 21 Sep 15
    - A database link is a pointer that defines a one-way communication path from an Oracle Database server to another database server.

    - The link pointer is actually defined as an entry in a data dictionary table.

    - To access the link, you must be connected to the local database that contains the data dictionary entry.

    - One principal difference among database links is the way that connections to a remote database occur.

    - Users access a remote database through the following types of links:

    - Connected user link - Users connect as themselves, which means that they must have an account on the remote database with the same user name and password as their account on the local database.

    - Fixed user link - Users connect using the user name and password referenced in the link.
    - For example, if Jane uses a fixed user link that connects to the hq database with the user name and password scott/password, then she connects as scott, Jane has all the privileges in hq granted to scott directly, and all the default roles that scott has been granted in the hq database.

    - Current user link - A user connects as a global user. A local user can connect as a global user in the context of a stored procedure, without storing the global user's password in a link definition. For example, Jane can access a procedure that Scott wrote, accessing Scott's account and Scott's schema on the hq database. Current user links are an aspect of Oracle Advanced Security.

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.)