Database users use SQL statements to work with data in the database instance. They can create and change database objects such as tables, views and indices.
Database users can log on to the following database tools and programming interfaces:
· SQL Studio, Web SQL Studio and SQLCLI (Query Tools)
· Loader
· ODBC, JDBC interface
Database users cannot perform any administration tasks. You need a Database Manager operator to create a new database instance or to perform backups, for example. The system database administrator (SYSDBA user) is the only database user who can log on to the Database Manager database tool as well.
Every database user belongs to a user class. The user classes are divided into the authorizations that their members have.
User classes
Name |
Properties |
Special User |
STANDARD |
Access to data and database procedures that were defined by other database users and for which the user has been given privileges. Definition of views, synonyms and temporary tables |
None |
RESOURCE |
Definition of data and database procedures Granting of privileges for these database objects to other database users |
None |
DBA (database administrator) |
Create RESOURCE and STANDARD database users Define database objects Granting of all or part of privileges for these database objects to other database users |
Database users are created, managed and deleted using SQL statements for user authorization. A database administrator (DBA user) has to log on to the database instance with a Query Tool (such as SQL Studio). To manage database users, you can also use the Database Manager GUI, see Managing Database Users.
A database administrator (DBA user) can only be created by the database system administrator (SYSDBA user). The database administrator (SYSDBA user) is created when the database instance is created.
Conventions for user names and passwords apply.