You must have certain permissions to create databases, and you must calculate the storage needed for database and related data.

To create databases, you need Create Databases permission on the database group that will contain the database and Use Template permission on at least one database configuration template.

It is useful to have the following permissions on the database group and on the database.

Create snapshots.

Create external backups.

Delete snapshots and manage their retention time.

Clone the database.

Recover the database from a backup or snapshot.

The organization administrator can create a role with these permissions and assign users in the organization to the role.

During the database creation process, you specify database storage allocation, point-in-time recovery storage allocation, and the database group for the database. The database group provides the CPU, memory, storage, and network resources required to run the database. The storage and point-in-time recovery allocations specify how much of the database group's resources to use for this database.

When you calculate the amount of storage to allocate to the database, proceed as follows.

Estimate how much data will be stored in the database.

Consider the number of users and average expected number of transactions in a particular time period and include room for growth.

If you plan to enable point-in-time recovery, calculate additional storage to accommodate the point-in-time recovery write-ahead logs (WALs). The size of the allocation depends on the expected volume of transactions on the database.

Database storage allocation is for the database data only. It does not include overhead for the operating system, database software, swap space, or snapshots. You must have enough resources available to cover both the database allocation and to cover any overhead. Even if the database group has enough free space for creating a database, database creation does not complete if you do not have enough resources for the overhead.

After database creation finishes, the following permissions on the new database are granted to the database creator.

Edit Database Info

Enables the database creator to edit database properties such as the name, description, and size of the database.

Modify Database Users

Enables the database creator to add or modify database users for this database. Database users are granted full permission on this database.

Restart Database

Enables the database creator to add or modify database users for this database. The database users are granted full permission on this database.

View Database

Enables the database creator to view the database.