Background documentationDatabase User Locate this document in the navigation structure

 

Database users can change data in the database using SQL statements. To execute SQL statements, they either log on to the database via interfaces or using query tools such as Database Studio or SQLCLI. Note that database users cannot log on to Database Manager CLI or perform administration tasks in Database Studio.

Database User Classes

Name

Properties

DBA

Database administrators

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

RESOURCE

Definition of data and database procedures

Granting of privileges for these database objects to other database users

STANDARD

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

Definition of view tables, synonyms and temporary tables

More Information

Database Administration, Database Users, Conventions for User Names and Passwords

Database Studio, Creating Database Users, Changing the Properties of Database Users, Deleting Database Users

SQL Tutorial, Database Users and Their Privileges

SQL Reference Manual, Authorization