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

  1. To restrict the ability to create databases to the informix user, add the following line to the onconfig file:
    DBCREATE_PERMISSION informix
  2. 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