| CONNECT |
CONN[ECT] username[/password][@hostname] [AS {SYSOPER | SYSDBA}]
|
Connects to a database using the specified username and password.
CONN[ECT] /[@hostname] [AS {SYSOPER | SYSDBA}]
Connects to the database using operating system authentication.
CONN[ECT] INTERNAL[/password]
Connects to a database internally.
Keywords
username
The Oracle username to use while connecting to the database.
password
The password associated with the provided username. If omitted, SQL*Plus will prompt for a password.
hostname
The hostname assigned to the database to which you are connecting. This hostname is typically resolved using the tnsnames.ora file or Oracle Names.
AS SYSOPER
Specifies that the user will connect as an operator.
AS SYSDBA
Specifies that the user will connect as a database administrator.
/
Specifies that the operating system username under which you are already logged in will be concatenated with the current value of the INIT.ORA parameter OS_AUTHENT_PREFIX(by default OPS$). The resulting username must exist as a database user (created with CREATE USER username IDENTIFIED EXTERNALLY). For example, if OS_AUTHENT_PREFIX is set to the default value and you are logged into the operating system or network as SCOTT, an Oracle username OPS$SCOTT must exist and have the CONNECT privilege.
INTERNAL
Specifies that an internal connection be made.
Get Oracle SQL: the Essential Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
