Show TOC

Background documentationDatabase Administrator (DBA User)

 

A database administrator is a database user of the database user class DBA. Database administrators can manage database users and database objects.

Database User Classes (User Mode)

Database User Class

Properties

DBA

Database administrators

Users belonging to this class can:

  • Create RESOURCE and STANDARD database users

  • Create database objects

  • Grant all or part of the privileges for their database objects to other database users

RESOURCE

Users belonging to this class can:

  • Define data

  • Create database procedures

  • Grant privileges for their database objects to other database users

STANDARD

Users belonging to this class can:

  • Access data and database procedures for which they have been granted the necessary privileges

  • Define view tables, synonyms, and temporary tables

The database system administrator is a special database user of database user class SYSDBA (administrator).