Database Administrator (DBA) option provides the user with these privileges within the user's space:
- CREATE USER
- DROP USER
- CREATE DATABASE
- DROP DATABASE
DBA users can only access or perform DML operations on objects that are under their immediate ownership. DBA users cannot access objects in a descendant's space. To perform DML operations on objects that are not owned by the DBA, the DBA must have the appropriate privileges to perform those operations or to be able to grant those privileges to other users.
- Removes the DBA option from the user.