The database system administrator (also called SYSDBA user) is the first database user. This user is created when a database is created. The default name for the database system administrator is DBADMIN.
This database system administrator has the most comprehensive rights of all database users. The database system administrator is a database administrator (database user of class DBA) and a DBM operator with all DBM server authorizations.
Name |
Properties |
---|---|
DBA |
Database administrators Creation of RESOURCE and STANDARD database users Definition of database objects Granting of all or part of privileges for these database objects to other database users |
RESOURCE |
Definition of data and database procedures Granting of privileges for these database objects to other database users |
STANDARD |
Access to data and database procedures that were defined by other database users and for which the user has been granted privileges Definition of view tables, synonyms and temporary tables |
Database Administration, Database System Administrator, DBM Operators, Conventions for User Names and Passwords
Database Studio, DBM Operators: Creating, Editing and Deleting
Database Manager CLI, Managing DBM Operators
SAP MaxDB Security Guide, Changing the Passwords of Standard Users