Database System Administrator (SYSDBA User)

Definition

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

?      The database system administrator is the owner of a number of system tables. When system tables are loaded, the load tool logs on to the database instance as database system administrator.

?      The database system administrator has all the server authorizations that a Database Manager operator can have. The database system administrator can therefore manage database instances with the Database Manager.

?      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 Database Manager operators.

The data of the database system administrator is saved in the Database Manager and in the database instance.

Structure

The database system administrator has DBM operator properties, server authorizations and SQL user properties.

DBM Operator Properties

General

Description

Name

Name of the database system administrator

Password

Password of the database system administrator

Comment

Description of the database system administrator

Disabled

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

Enable Pwd

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 authorizations (server rights) are authorizations for the DBM Server program and thereby for executing actions in the Database Manager (see the list of server authorizations for the DBM Server).

SQL User Properties

General

Description

Name

Name of the database system administrator

Password

Password of the database system administrator

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 two different database sessions simultaneously.

Extended

Description

Timeout

Setting the timeout value

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 DEFAULT_CODE.

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

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

Managing the Database System Administrator

The database system administrator (SYSDBA user) is the first database user that you create when you create a database instance with the Database Manager or the Installation Manager.

As of database version MaxDB 7.6, the default value for the name of the database system administrator is DBADMIN.

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

?      Database Manager GUI
Changing the DBM User Properties of the Database System Administrator
Changing the Password of the Database System Administrator
Changing the Server Authorizations of the Database System Administrator
Changing the SQL User Properties of the Database System Administrator

Database Manager CLI
user_get
user_getrights
user_put

?      SQL Reference Manual
ALTER USER Statement (alter_user_statement)
ALTER PASSWORD Statement (alter_password_statement)

See also:

Users, Authentication and Authorizations

Conventions for User Names and Passwords