Session 

When users are defined, they are assigned a password. To be able to work with a database instance, users must specify their user name and password.

If the user name and password are valid, the user is given access to the database instance. By doing so, the user opens a session and the first transaction.

A user can only work with the database instance within a session. A session is always terminated explicitly by the user.

The user name required to obtain access to the database instance is referred to as the "current user" if the user is not a member of a usergroup. If the user is a member of a usergroup, the name of the usergroup is the "current user".

See also:

Users and usergroups

Password

CONNECT statement

SET statement