Procedure documentationLogging On to a Database Locate this document in the navigation structure

Procedure

Selecting or Adding Users and Logging On

  1. In the context menu of the database, choose Login.

  2. Enter user name and password of the user with which you want to log on.

    Authentication Information

    Property

    Description

    User Name

    Users fall into two groups:

    • DBM operators: These users can perform administrative tasks.

    • Database users: Database users can change data in the database.

    The database system administrator (default name DBADMIN) belongs to both groups and has the most extensive authorizations.

    More information: Database Administration, Managing Users

    User Password

    The database system converts all letters to uppercase.

    To use upper and lower case letters and/or special characters for a user name or a password, select the Case Sensitive checkbox.

    More information: Database Administration, Conventions for User Names and Passwords

    Template

    You can save your login data as template for use with other databases.

    Communication

    In SAP systems, you can enable SSL encryption (if configured during installation)

    More information: Encryption

    Details

    You can use Oracle SQL Mode.

    More information: SQL Mode

    To test whether the user name and password you have entered are valid, choose Test Login.

    Note that if the database is not in the ONLINE operational state, this test will fail for database users (but not for the database system administrator or DBM operators) even if user name and password are valid.

Creating User Templates

You can define templates to use the same logon data for users of different databases, which are then available in all databases of the same server or landscape. You can define templates for the database system administrator, DBM operators, and database users.

  1. Choose Up One Level (Up One Level) until the desired computer or landscape is displayed in the explorer.

  2. In the context menu, choose Login Templates.

  3. Choose New.

  4. Enter a template name, a user name and a user password.

    To generate the user name from the database name for which you use the login template later, enter <DBNAME> as part of the user name and select Replace With Database Name (e.g. SAP<DBNAME>DB).

    Example Example

    You enter the user name SAP<DBNAME>DB.

    When you use this login template for logging on to the TEST database, SAPTESTDB is used as user name.

    When you use this login template for logging on to the PROD database, SAPPRODDB is used as user name.

    End of the example.

  5. To add the login based on this login template to the database you have currently selected in the explorer tree, choose Assign.

Selecting a Database Connection

To open some of the views and editors in the Database Studio, you have to select a database connection (database name, user name, user password) first.

More Information