Fixed user in database link has username/password as part of the link definition - Oracle

Q.  Which user type in a database link has username/password as part of the link definition?
- Published on 27 Jul 15

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

ANSWER: Fixed user
 

    Discussion

  • Nirja Shah   -Posted on 21 Sep 15
    - When creating the link, you determine which user should connect to the remote database to access the data.

    - The following table explains the differences among the categories of users involved in database links:

    - Connected user
    - A local user accessing a database link in which no fixed username and password have been specified.
    - If SYSTEM accesses a public link in a query, then the connected user is SYSTEM, and Oracle connects to the SYSTEM schema in the remote database.

    - Current user
    - A global user in a CURRENT_USER database link. The global user must be authenticated by an X.509 certificate (an SSL-authenticated enterprise user) or a password (a password-authenticated enterprise user), and be a user on both databases involved in the link.
    - Current user links are an aspect of the Oracle Advanced Security option.

    - Fixed user
    - A user whose username/password is part of the link definition.
    - If a link includes a fixed user, then the fixed user's username and password are used to connect to the remote database.

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