Background documentationSQL User Properties Locate this document in the navigation structure

 

Database users have a range of SQL user properties.

SQL Properties of Database Users

Property

Description

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.

Caution Caution

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

End of the caution.

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.

ASCII

UNICODE

More Information

Database Administration, Database Users

Database Studio,

SQL Reference Manual, CREATE USER Statement