Snippet Name: Database Links: CURRENT_USER
Description: To create a current user database link, use the CONNECT TO CURRENT_USER clause in the link creation statement. Current user links are only available through the Oracle Advanced Security option.
The following syntax creates a current user database link, where dblink is the name of the link and net_service_name is an optional connect string.
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.
Also see:
» Add PSOUG Search to SQL Developer
» Converting Rows to Columns
» Instant Test Database with DCBA
» Show info on current context
» Lookup Oracle error messages
» Display and release DBMS_LOCK locks
» Display locks and latches
» Show rollback segment stats
» Show active transactions
» List supported INIT.ORA parameters
» Display database SGA statistics
» Measure the Buffer Cache Hit Ratio
» List security related profile informat...
» Find users with deadly privileges
» Audit User Logins (User Login Trigger)
» Block TOAD and other tools
» Kill Session
» Extents
» DBA Users
» DBA Tablespaces
» DBA triggers
» DBA Sessions
» DBA Roles
» DBA Objects
» DBA Links
» DBA Jobs
» Job Queue
» DBA Free Space
» Data Files
» DBA Extents
Comment: (none)
Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 07th, 2009
|
CREATE [SHARED] [PUBLIC] DATABASE LINK dblink
CONNECT TO CURRENT_USER
[USING 'net_service_name'];
-- A public link called pu_link to the database with
-- service name 'supply'. The link uses the userid/password
-- of the current user to log onto the remote database.
CREATE PUBLIC DATABASE LINK pu_link
CONNECT TO CURRENT_USER USING 'supply';
-- A public fixed user link to the remote vehicles database.
-- The link connects to the remote database with the
-- userid/password of mike/rogers.
CREATE PUBLIC DATABASE LINK vehicles.cardealer.com
CONNECT TO mike IDENTIFIED BY rogers; |
