Authenticating users with Oracle

Oracle users can be authenticated in different manner: as database users, as operating system users or with another external authentication method like Kerberos.

If you don't specify the USER/USING clause, OS authentication takes place.

An Oracle connection can also be established as SYSDBA or SYSOPER users. This is possible by specifying the following strings after the user name in the USER clause of the CONNECT TO instruction:

Table 1. Oracle connection as SYSDBA or SYSOPER
String passed to USER clause after user name	Effect as Oracle connection
`/SYSDBA`	Connection will be established as SYSDBA user.
`/SYSOPER`	Connection will be established as SYSOPER user.

You must specify the user login before the /SYSDBA or /SYSOPER strings:

CONNECT TO "orc1fox+driver='dbmoraA2x'"
    USER "orauser/SYSDBA" USING "fourjs"