Database User

Definition

Database users can use SQL statements to work with data in the database instance. You can create and change database objects such as tables, views and indexes.

Database users can log on to the following database tools and programming interfaces:

?      SQL Studio, Web SQL Studio and SQLCLI (query tools)

?      Loader

?      ODBC, JDBC, SQLDBC interfaces

?      Synchronization Manager

Database users cannot perform database administration tasks with the Database Manager.

Structure

Database users have a range of SQL user properties.

SQL User Properties

General

Description

Name

Name of the database user

Password

Password of the database user

User Class

Database user class (DBA | RESOURCE | STANDARD)

Connection Mode

NOT EXCLUSIVE: allows the database user to open several database sessions simultaneously.

EXCLUSIVE: each database user can open only one database session.

DISABLED: the database user may not open any database sessions.

Extended

Description

Timeout

Setting the timeout value

Cost Warning

Specifies the estimated SELECT cost value beyond which the user receives a warning. In this case, 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.

Replication User

If Replication User is selected, a special database user (database user class DBA, connection mode NOT EXCLUSIVE), who is required for synchronizing database instances with the Synchronization Manager program, is created or maintained.

Every database user belongs to a database user class. The user classes are distinguished by the authorizations that their members have.

Database User Classes

Name

Properties

STANDARD

Access to data and database procedures that were defined by other database users and for which the user has been given privileges.

Definition of view tables, synonyms and temporary tables

RESOURCE

Definition of data and database procedures

Granting of privileges for these database objects to other database users

DBA (database administrator)

Creation of RESOURCE and STANDARD database users

Definition of database objects

Granting of all or part of privileges for these database objects to other database users

Managing Database Users

The database system administrator (SYSDBA user) can create database users of any database user class, including users of the DBA (database administrator) user class. Any database administrator can create users of the user classes RESOURCE and STANDARD.

You use SQL statements to create, manage and delete database users. You have the following options for managing database users:

Use a suitable query tool (such as the SQL Studio) and enter SQL statements directly.
See: SQL
Reference Manual, Authorization

?      Use the Database Manager GUI.
See:
Database Manager GUI, Managing Database Users.

The synchronization user is a special database user (SQL user properties, database user class DBA, connection mode NOT EXCLUSIVE, replication user) required for synchronizing database instances with the Synchronization Manager program. You can use the Database Manager GUI to manage the synchronization user: Creating/Changing/Deleting a Synchronization User.

You can assign special roles to database users in the SAP system. See

Database Administration in CCMS: SAP liveCache Technology, Authorization Concept

Database Administration in CCMS: MaxDB, Prerequisites

Creating, Changing, Deleting Database Users / Managing SQL User Properties

A database user of the database user class DBA or the database system administrator (SYSDBA user) can create, change or delete other database users and display or change the SQL user properties of those database users.

To do this, proceed as described in the following sections:

?      Database Manager GUI
Creating/Changing/Deleting a Database User
Changing the SQL User Properties of a Database User
Changing the Password of a Database User
Creating/Changing/Deleting a Synchronization User

?      SQL Reference Manual
CREATE USER Statement (create_user_statement)
ALTER USER Statement (alter_user_statement)
ALTER PASSWORD Statement (alter_password_statement)
DROP USER Statement (drop_user_statement)

Database Administration in CCMS: MaxDB, User Data

Database Administration in CCMS: SAP liveCache Technology, User Data

See also:

Users, Authentication and Authorizations

Conventions for User Names and Passwords