Entering content frame

Object documentation Database Users Locate the document in its SAP Library structure

Definition

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

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 interface

Caution

Database users cannot perform any administration tasks. You need a Database Manager operator to create a new database instance or to perform backups, for example. The system database administrator (SYSDBA user) is the only database user who can log on to the Database Manager database tool as well.

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

User classes

Name

Properties

Special User

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 views, synonyms and temporary tables

None

RESOURCE

Definition of data and database procedures

Granting of privileges for these database objects to other database users

None

DBA (database administrator)

Create RESOURCE and STANDARD database users

Define database objects

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

Database System Administrator (SYSDBA User)

Database users are created, managed and deleted using SQL statements for user authorization. A database administrator (DBA user) has to log on to the database instance with a Query Tool (such as SQL Studio). To manage database users, you can also use the Database Manager GUI, see Managing Database Users.

A database administrator (DBA user) can only be created by the database system administrator (SYSDBA user). The database administrator (SYSDBA user) is created when the database instance is created.

Conventions for user names and passwords apply.

 

Leaving content frame