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, Use Templates permission on at least one database template, and permission to at least one resource template and one backup template.

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

Create snapshots.

Create external backups.

Delete snapshots, including editing their retention time.

Clone the database.

Recover the database from a backup or snapshot.

Manage IP Whitelists

The organization administrator can create a role with these permissions and assign organization users 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. See Storage Reservation.

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 allow for the number to increase.

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.

Every database requires a certain amount of storage overhead for the operating system, database software, swap space, log files, snapshots, and so on. The storage for overhead is explicitly allocated and does not count against database storage allocation. Database storage allocation is for the database schema and data only. You must have enough resources available to cover 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 finish if you do not have enough resources for the overhead. If the free space is less than the following calculation, Data Director cannot create the database.

(storage allocation * storage reservation %) + overhead

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

Edit information and storage

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

Manage IP whitelists

Enables the database creator to assign IP whitelists to this database and to create custom IP whitelists for this database.

Modify administrator accounts

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

Start database and Stop database

Enables the database creator to start and stop.

View properties

Enables the database creator to view the database.

Edit settings

Enables database creators to edit database parameters, database ingestion, and refresh settings and SSL certificates.

Monitor status

Enables database creators to monitor dashboards, events, tasks, reports, and logs. You can also define, monitor, and acknowledge alarms.