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

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