Setting permission to create databases
Use the DBCREATE_PERMISSION configuration parameter to give specified users permission to create databases and thus prevent other users from creating databases.
About this task
If you do not set the DBCREATE_PERMISSION configuration parameter, any user can create a database.
The informix user always has permission to create databases.
To set permission to create databases:
Procedure
- To restrict the ability to create databases to the informix user,
add the following line to the onconfig file:
DBCREATE_PERMISSION informix
- You can include multiple instances of DBCREATE_PERMISSION in
the onconfig file to give additional users permission
to create databases.For example, to grant permission to a user named watsonjay, add this line to the onconfig file:
DBCREATE_PERMISSION watsonjay