Home | Previous Page | Next Page   The Database Server > Security > 3 3 3

Setting Permission to Create Databases

3

Use the DBCREATE_PERMISSION configuration parameter to 3give specified users permission to create databases and thus prevent other 3users from creating databases. If this parameter is not set, any user can 3create a database.

3

The informix user always has permission to create 3databases. To restrict the ability to create databases to the informix user, add the following line to the ONCONFIG file:

3
DBCREATE_PERMISSION informix
3

You can include multiple instances of DBCREATE_PERMISSION in the ONCONFIG 3file to give additional users permission to create databases. For example, 3to grant permission to a user named watsonjay, add this 3line to the ONCONFIG file:

3
DBCREATE_PERMISSION watsonjay
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]