Logging On to a Database
To use the SQLCLI interactively (in session mode), you log on to the database as a database user. This opens a database session.
The specified user is a database user.
More information: Database Administration, Database Users
One Step Logon
Enter the following command:
sqlcli [<options>] -d <database_name> -u <database_user>,<database_user_password>
|
Property |
Description |
|---|---|
|
<options> |
Call options for SQLCLI More information: Overview of All SQLCLI Call Options |
|
<database_name> |
Database Name |
|
<database_user> |
Name of the database user More information: Database Administration, Conventions for User Names and Passwords |
|
<database_user_password> |
Password of the database user |
One step logon to the DEMODB database on the PARMA computer as database user MONA with the password RED.
sqlcli -n PARMA -d DEMODB -u MONA,RED
To log on using a <user_key>, enter the following command:
sqlcli [<options>] -U <user_key>
More information: XUSER documentation
Two Step Logon
-
Start SQLCLI:
sqlcli [<options>]
-
Log on to the database:
\c [<options>] -d <database_name> -u <database_user>,<database_user_password>