Databases Reference
In-Depth Information
The
tnsentry
found in the
tnsnames.ora
file (
E
) is just a regular
tnsentry
, the
name defined here must match the parameter used with the
createCredential
option of the
mkstore
command.
SCOTT_SECURE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = alpha)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = beta)
)
)
And finally, the most interesting part of the procedure, using the credentials stored
for the particular
tnsentry
, a new connection is opened against the database
without exposing the database user name and its password (
F
).
sqlplus /@SCOTT_SECURE
It is then confirmed that the user has successfully opened a database session (
G
).
SQL> SHOW USER
USER is "SCOTT"
Search WWH ::
Custom Search