Every database user belongs to a database user class. User classes are distinguished by the authorizations that their members have.
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 |
Database Administration, Database Users
Database Studio, Creating Database Users, Changing the Properties of Database Users
SQL Tutorial, Database Users and Their Privileges
SQL Reference Manual, CREATE USER Statement