Prevents users from logging in to any databases in an application. Supervisors and application designers for the application, are not affected by this setting, but users (lower than application designer privileges) currently connected to the application are affected.
DISABLELOGIN [appName]
appName | Optional. Application name required only if no application is selected. |
Issue the DISABLELOGIN command if you must prevent users from accessing databases in an application while you perform maintenance on it. Supervisors and application designers for the application, are not affected by this setting, but users (lower than application designer privileges) currently connected to the application are affected.
The DISABLELOGIN command prevents any user with a permission lower than Application Designer 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 default, connections are enabled.
DISABLELOGIN;
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |