Database User

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
Database User Class	Properties
DBA	Database administrators Users belonging to this class can: Create RESOURCE and STANDARD database users Create database objects Grant all or part of the privileges for their database objects to other database users
RESOURCE	Users belonging to this class can: Define data Create database procedures Grant privileges for their database objects to other database users
STANDARD	Users belonging to this class can: Access data and database procedures for which they have been granted the necessary privileges Define 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