Show TOC

Database Administrator (DBA User)Locate this document in the navigation structure

Use

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

Table 1: 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).