Background documentationDatabase System Administrator Locate this document in the navigation structure

 

The database system administrator (also called SYSDBA) has all the authorizations that a database user of the DBA database user class can have, plus the following properties:

  • The database system administrator is the owner of several system tables.

    When a database tool loads the system tables, it logs on to the database as database system administrator.

  • The database system administrator has all the server authorizations that a DBM operator can have. The database system administrator can manage databases.

  • The database system administrator has owner rights over all database users. The database system administrator can create database users of any database user class and can also create DBM operators.

Properties
SQL User Properties of the Database System Administrator

SQL User Properties

Description

User Class

Database user class (SYSDBA)

Connection Mode

NOT EXCLUSIVE: Allows the database system administrator to open several database sessions simultaneously

EXCLUSIVE: Prevents the database system administrator from opening database sessions simultaneously

Session Timeout

Length of time after which the database session is ended if the database system administrator is inactive

Cost Warning

Specifies the estimated SELECT cost value beyond which the user receives a warning. If a warning is issued, the user is asked whether he or she really wants to execute the SQL statement.

Cost Limit

Specifies the estimated SELECT cost value beyond which the SQL statement is not executed. This value must be greater than the Cost Warning value.

Default Code

DEFAULT: The default value for the code attribute is defined by the database parameter DefaultCodePage.

ASCII: The default value for the code attribute is ASCII.

UNICODE: The default value for the code attribute is Unicode.

DBM Operator Properties of the Database System Administrator

Property

Description

Disabled

Specifies whether the user account of the database system administrator is locked

Enable Second Password

You can define a second password for the database system administrator. This way you can temporarily allow other people to work with the database system administrator (for example, for support purposes) without the database system administrator having to reveal or change the original password.

Server authorizations (Server Rights) are authorizations for the DBM server program and hence for managing databases.

DBM Server Permissions

Permission

Required for Logon to a Database with Database Studio

Name in Database Manager CLI

Accessing an SQL session

Yes

AccessSQL

Access to Utility sessions

-

AccessUtility

Executing backups

-

Backup

Accessing database files (reading only)

Yes

DBFileRead

Displaying status information

Yes

DBInfoRead

Starting the database

-

DBStart

Stopping the database

-

DBStop

Using the Loader program

-

ExecLoad

Installation management

-

InstallMgm

Loading the system tables

-

LoadSysTab

Accessing database parameters (reading and writing; only those commands for changing parameters may be executed whose changes are checked against the default parameter file cserv.pcf)

-

ParamCheckWrite

Accessing database parameters (reading and writing; all commands can be executed, even those for directly changing the parameter file without the changes being checked by the system)

-

ParamFull

Accessing database parameters (reading only)

Yes

ParamRead

Restoring databases

-

Recovery

Managing the scheduler

-

SchedulerMgm

Scheduling DBM commands

-

Scheduling

Managing the shared memory

-

SharedMemoryAdmin

Executing operating system commands

-

SystemCmd

Managing DBM operators

-

UserMgm

Managing the Database System Administrator

The database system administrator is the first database user you create when creating the database. The default value for the name of the database system administrator is DBADMIN.

You can use Database Studio, Database Manager CLI or a query tool to display or change the SQL user properties, DBM operator properties and DBM server permissions of the database system administrator.

Database Studio, DBM Operators: Creating, Editing and Deleting

Database Manager CLI, user_get, user_getrights, user_put

SQL Reference Manual, ALTER USER Statement, ALTER PASSWORD Statement