Database Manager Operator (DBM operator)
• Can login to the Database Manager GUI & CLI.
• Cannot log on to the query tools SQLCLI, SQL Studio
• Can have multiple logins.
• DBM operator is defined during the installation.
• Can create multiple DBM operators.
• Name and password are in uppercase characters. Maximum length of 18 characters (9 characters in UNICODE). Special characters are not permitted.
• Eg: CONTROL
Database user
• Can login to the query tools SQLCLI, SQL Studio.
• Cannot log on to the Database Manager.
• The database system uses several different database user classes. The most important are:
Database system administrator (SYSDBA user)
• SYSDBA user is the initial database user.
• Created during the installation
• SYSDBA user can then use the query tools to define other database users.
• Can define database objects and grant other database users privileges for these database objects.
• SYSDBA user is the owner of system tables. When system tables are uploaded, the upload tool logs on to the database instance as SYSDBA.
• SYSDBA user is the only database user who also has the authorizations of a Database Manager operator.
• Eg: SUPERDBA
Database administrator (DBA user)
• Created by the SYSDBA user.
• DBA users themselves can create database users of the classes RESOURCE and STANDARD.
• Can define database objects and grant other database users all or some privileges for these database objects.
• Eg: SAPSR3, SAPR3, SAP
