Users and Usergroups
User names and passwords are defined when the database system is installed.
responsible for controlling, monitoring, and backing up the database system.
installs the database system, i.e. creates users etc. The database administrator is the owner of the system tables and is granted the privilege of defining other administrators.
maintains the system tables. His or her name is always DOMAIN. Any password can be selected.
Information on installing the system is provided in the documentation entitled R/3 Database Manager.
There are four hierarchical groups of users in WARM database mode:
can only access existing tables for which they have received privileges. They can define synonyms and view tables for these tables. A STANDARD user can only create temporary tables.
have all the rights of a STANDARD user. In addition, they can create private tables and grant privileges for them.
are responsible for the organization of the database system. The DBA has all the rights of a RESOURCE user. Database administrators can create RESOURCE users and STANDARD users.
installs the system. The system database administrator has all the rights of a DBA. In addition, he or she can create users with DBA status.
Each database only has one SYSDBA.
Usergroups can also be defined. All of the members of a usergroup have the same rights with regard to data assigned to the group.
See also:
User name Usergroup name CREATE USER statement CREATE USERGROUP statement