Connecting to Another Database¶
When you are connected to a database, you can connect to other databases
or use different credentials to execute tasks that with your
current user, you are not allowed to. To do this, use the commands
CONNECT
and CLOSE
.
CONNECT
[
{ USER <name:identifier> PASSWORD <password:literal>
| TOKEN <token:literal> }
]
[ DATABASE <name:identifier> ]
The CONNECT
command allows indicating either a user name (USER
)
and password (PASSWORD
) or a Kerberos token, to initiate a new
session in the server with a new user account. A session may also be
initiated with a new database (with the current user or another user).
If you indicate the credentials but not DATABASE
, this command opens a session to the database you are already connected to, with the credentials provided.
The CLOSE
command allows the previous session to be reestablished
after having established a new session with the CONNECT
command.