User Guide

SAP AG November 2002
User Concept ....................................................................................................................... 25
SAP DB User Classes...................................................................................................... 26
Database Manager Operator (DBM Operator) ............................................................. 26
Authorizations ........................................................................................................... 27
User Authorizations ............................................................................................... 27
Default Authorizations for the First DBM Operator ............................................ 28
Operating System User Authorizations ................................................................. 28
Database User.............................................................................................................. 28
Database User Classes ............................................................................................ 28
SYSDBA ................................................................................................................ 29
DBA ....................................................................................................................... 29
DOMAIN ................................................................................................................ 29
RESOURCE .......................................................................................................... 30
STANDARD........................................................................................................... 30
User Groups.............................................................................................................. 30
The Role Concept ............................................................................................................ 30
User Data as Options ....................................................................................................... 31
Options (C/C++ Precompiler) ....................................................................................... 32
Required Options ............................................................................................................. 34
User Data and XUSER..................................................................................................... 34
Using XUSER................................................................................................................... 35
XUSER Data................................................................................................................. 35
Generating XUSER Data in the Background................................................................ 36
Security Concepts................................................................................................................ 37
Availability......................................................................................................................... 38
Security Requirements ................................................................................................. 38
Restartability..................................................................................................................... 38
Backup Strategy ............................................................................................................... 39
Backup .......................................................................................................................... 40
Data Backup.............................................................................................................. 40
Complete Data Backup.......................................................................................... 40
Incremental Data Backup ...................................................................................... 41
Parallel Backup...................................................................................................... 41
Saving Data Backups ............................................................................................ 41
Log Backup ............................................................................................................... 41
Automatic Log Backup........................................................................................... 42
Interactive Log Backup.......................................................................................... 42
Saving Log Backups.............................................................................................. 43
External Backup Tool.................................................................................................... 43
Log Concept......................................................................................................................... 43
User Manual: SAP DB 5