Show TOC

Creating Database UsersLocate this document in the navigation structure

  • The database is in the ONLINE operational state.

  • You are logged on to the database as database system administrator or as a database user of the DBA user class.

  1. Select the database in the explorer tree.

  2. In the context menu of the users, choose Start of the navigation path New Next navigation step User End of the navigation path.

  3. Enter the following data:

    User name and password (confirm password).



    Database User Class

    Database user class (user mode 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.


    This connection mode only exists still for historical reasons. Do not use it. Database users with this connection mode cannot work with Database Studio.

    DISABLED: The database user is locked and cannot open any database sessions.

    Session Timeout

    Time after which the database session is ended after user inactivity.

    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 Attribute

    Default code attribute for creating new columns

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




The current user becomes the owner of the database user.

More Information

Managing Users: Overview

Database Administration, Database Users