User Guide

SAP AG November 2002
• DBA [Page 137]
• DOMAIN [Page
137]
• RESOURCE [Page
146]
• STANDARD [Page
30]
SYSDBA
The SYSDBA user (database system administrator) is a special database user [Page 136] of
the database user class [Page 28] SYSDBA. The SYSDBA user is the first database user that
is created when a new database instance [Page 132] is installed. Enter a user name and
password for this user.
Each database instance has one single SYSDBA user.
The SYSDBA user’s password can be changed once the database registration has finished.
The SYSDBA user is very important, especially when database instances are installed. The
SYSDBA user is responsible for setting up the system and for creating other database users.
The SYSDBA user is the owner of system tables. When system tables are uploaded, the
upload tool logs on to the database instance as SYSDBA.
The SYSDBA is able to define data and database procedures. The SYSDBA can also grant
other users privileges for these database objects.
DBA
DBA users (database administrators) are special database users [Page 136] of the database
user class [Page 28] DBA. They are created by the SYSDBA [Page 151].
A DBA user is authorized to create RESOURCE [Page 146] and STANDARD users [Page
30]. The DBA user can also define data and database procedures and grant other users all or
some DBA user privileges for these database objects.
A DBA user can group users with identical access rights into user groups [Page
30].
A special DBA user is the user DOMAIN [Page
137].
DOMAIN
The DOMAIN user is a special database user [Page 136] of the database user class [Page
28] DBA [Page 137]. The DOMAIN user is the owner of the system tables of the database
catalog [Page 131].
Just like the SYSDBA [Page
151] user, the DOMAIN user is created when a database
instance [Page 132] is installed. The DOMAIN user is created by the system under the pre-
defined name DOMAIN. The password is the same as that of the SYSDBA user that was
created earlier.
The DOMAIN user’s password can be changed at a later date.
User Manual: SAP DB 29