Controlling Logons

The following TCL commands are supported to control logons to the database:

ENABLE-LOGONSEnables logons to the database for all ports. A new database is locked to all users except the database owner (the user who created the database) and superuser until either this, or the system-level command unlockdbase is executed.

INHIBIT-LOGONSPrevents all users except super-user and, depending on options, the database owner logging on to the database.

LOGOFFLogs off a specified port and disconnects it from the database.

LOGOFF-ALLLogs off all or a range of ports and disconnects them from the database.

LOGONLogs another port on.

LOGTOLogs from one account to another.

NET-LOGONLogs another port on remotely from across a network.

OFFLogs a user off the database.

SHUTDOWNLogs off all database users.