Logging on to a Database Instance

Use

To use the SQLCLI interactively (in session mode), log on to a database instance as a database user: This opens a database session.

Prerequisites

The specified user is a database user.

One Step Logon

Log on to the database instance:

sqlcli [<options>] -d <database_name> -u <database_user>,<database_user_password>

<options>

Call options for the SQLCLI program

<database_name>

Name of database instance

<database_user>

Name of the database user

See Concepts of the Database System, Conventions for User Names and Passwords

<database_user_password>

Password of the database user

One step logon to the database instance DEMODB on the computer PARMA as database user MONA with the password RED:

sqlcli -n PARMA -d DEMODB -u MONA,RED

To log on using a user key <user_key>, enter the following command:

sqlcli [<options>] -U <user_key>

Two Step Logon

Start the SQLCLI:

sqlcli [<options>]

Log on to the database instance:

\c [<options>] -d <database_name> -u <database_user>,<database_user_password>

Result

You have opened a database session and can now execute commands interactively.

See also:

Overview of the SQLCLI Commands