DISABLE LOGONS/ DISABLE ALL LOGONS - Advanced SQL Engine - Teradata Database

Database Utilities

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-15
dita:mapPath
boh1556732696163.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1102
lifecycle
previous
Product Category
Teradata Vantageā„¢

Purpose

Prevents users from logging on to the system until the ENABLE LOGONS or ENABLE ALL LOGONS command is sent.

Syntax

DISABLE [ALL] LOGONS

Usage Notes

DISABLE LOGONS and DISABLE ALL LOGONS are synonymous.

To use this command, the current logon state must be one of the following:
  • Logons are enabled - The system is quiescent.
  • Only user DBC logons are enabled - The system is quiescent.
To see the current logon state, use one of the following commands:
  • from DBW: QUERY STATE
  • from a Teradata Command Prompt: pdestate -a

Teradata Database must be running for the change to be applied. A database restart is not required for the new setting to take effect.

Users logged on to the system before the DISABLE LOGONS or DISABLE ALL LOGONS command is executed remain logged on, and their jobs continue to run. All sessions are reconnected if the system is restarted.

Both commands (DISABLE LOGONS or DISABLE ALL LOGONS) update the Start With Logons value in the PDE Control GDO, which is viewable using the Control GDO Editor (ctl) utility. For more information, see Control GDO Editor (ctl).

Example: Disabling user logons to the database

The following example shows the current logon status is disabled for all new users.

disable logons

12/02/12 10:05:02 Logons disabled.