CONNECT

Start a user session.

Syntax:

   CONNECT username [AS {SYSDBA|SYSOPER}]

   CONNECT username/password [AS {SYSDBA|SYSOPER}]

   CONNECT username/password@sid [AS {SYSDBA|SYSOPER}]


options:
   username   An Oracle User
   sid        Database System ID

In Oracle versions up to 8i 'INTERNAL' is a synonym for 'sys AS SYSDBA'

Example

SQL> connect system
Enter password: *******
Connected.

SQL> show user
USER is "SYSTEM"

SQL> connect system as sysdba
Enter password: *******
Connected.

SQL> show user
USER is "SYS"

"Onstage I'm the happiest person in the world" - Britney Spears

Related Commands:

COMMIT
DISCONNECT
ROLLBACK
ALTER SYSTEM ENABLE RESTRICTED SESSION
SET TRANSACTION

Related Views:

 DBA_PENDING_TRANSACTIONS
                                           USER_RESOURCE_LIMITS
 V$SESSION
 V$SESSION_CONNECT_INFO
 V$SESSION_CURSOR_CACHE
 V$SESSION_EVENT
 V$SESSION_LONGOPS
 V$SESSION_OBJECT_CACHE
 V$SESSION_WAIT
 V$SESSTAT
 V$SESS_IO