Database-level privileges

The three levels of database privileges provide an overall means of controlling who accesses a database. Only individual users, not roles, can hold database-level privileges.

Connect privilege
The least of the privilege levels is Connect, which gives a user the basic ability to query and modify tables.
Resource privilege
The Resource privilege carries the same authorization as the Connect privilege. In addition, users with the Resource privilege can create new, permanent tables, indexes, and SPL routines, thus permanently allocating disk space.
Database-administrator privilege
The highest level of database privilege is database administrator, or DBA. When you create a database, you are automatically the DBA.

Parent topic: Grant privileges