DBCREATE_PERMISSION configuration parameter

Use the DBCREATE_PERMISSION configuration parameter to restrict the permission to create databases to the user that you specify.

The informix user always has permission to create databases. To restrict the ability to create databases to the informix user, set the DBCREATE_PERMISSION configuration parameter to informix.

onconfig.std value
On UNIX: Not set. Any user can create databases.
On Windows: #DBCREATE_PERMISSION informix
default value
Any user can create databases.
units
user names
separator
Comma. You can also include multiple copies of the DBCREATE_PERMISSION configuration parameter in the onconfig file to give more users permission to create databases.
takes effect
After you edit your onconfig file and restart the database server.

The DBCREATE_PERMISSION configuration parameter does not provide permissions to create tenant databases. Users must have the TENANT privilege to create tenant databases. Grant the TENANT privilege by running the admin() or task() SQL administration API function with the grant admin argument.


Copyright© 2019 HCL Technologies Limited