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
- #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.