Switches That Start and Stop Databases
The
-gd option lets you limit the users who can
start or stop a database on a running server to those with a certain
level of privilege in the database to which they are already connected:
- DBA –
(default value) only users with
SERVER
OPERATOR system privilege can start an extra
database.
- ALL –
(default in start_iq and default.cfg) any user can start and
stop databases. This setting means that the DBA does
not need to issue START
DATABASE commands. Users must still be
granted the privileges to access a particular
database once he or she has started it.
- NONE
– no one can start or stop a database from
Interactive SQL on a running server.
Note: If -gd ALL is not set when you start the
server, only
a
user with the SERVER OPERATOR system privilege can start
additional databases on that server. This means that users
cannot connect to databases that are not already started,
either at the same time as the server, or since then by
a
user with the SERVER OPERATOR system privilege. However, it
also lets
a
user without the SERVER OPERATOR system privilege stop a
database. For this reason, you may want to change this
setting to DBA on production databases.