Prevents users from logging in to databases in an application. Administrators and application managers for the application are not affected by this setting, but other connected users are affected.
Syntax
DISABLELOGIN [appName]
Parameter | Description |
---|---|
appName | Optional. Required only if no application is selected. |
Notes
Issue the DISABLELOGIN command to prevent users from accessing databases in an application during maintenance. Administrators and application managers are not affected.
The DISABLELOGIN command prevents any user with a permission lower than Application Manager from making connections to the databases that require the databases to be started. This includes starting the databases or performing the SELECT command on the databases.
Database connections remain disabled until re-enabled by as follows:
By the administrator, using ENABLELOGIN.
By the administrator, using application settings. In Administration Services, select the Allow Connects check box under the Security node in the Application Properties window - General tab.
By default, connections are enabled.
Example
DISABLELOGIN;
See Also