Database User Class

Use

Every database user belongs to a database user class (user mode DBA, RESOURCE, STANDARD). These database user classes have different authorization levels for the database. The database system administrator is a special database user of database user class SYSDBA (administrator).

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

More Information

Database Administration, Database Users, Database System Administrator
Database Administration in CCMS, User Data
Database Studio, Managing Users: Overview
SQL Reference Manual, Authorization
SQL Tutorial, Database Users and Their Privileges
SAP MaxDB Security Guide, User Administration and Authentication, Authorizations