You use the Database Manager GUI to create a database user, change the properties of a database user, or delete a database user.
The database instance is in the ONLINE operational state.
...
1. Choose Instance ® Configuration ® Database User... .
2.
Enter the name and password of a database user of
the database user class DBA, that is, a database administrator (DBA user).
To create a database administrator (DBA user), enter the name and password of
the database system administrator (SYSDBA user).
To create a database user of the STANDARD or RESOURCE class, enter the name
and password of the database system administrator (SYSDBA user) or a database
administrator (DBA user).
3. Choose New User.
4. Choose the General tab page and enter the desired SQL operator properties.
SQL User Properties
General |
Description |
Name |
Enter a name for the new database user. |
Password |
Enter a password for the new database user. |
Confirm Password |
Confirm the password. |
User Class |
Choose the database user class (DBA | STANDARD | RESOURCE). |
Connection Mode |
You can set the following connection modes: ● The database user can open several database sessions at once (NOT EXCLUSIVE). ● Each database user can open only one database session (EXCLUSIVE). ● The database user may not open any database sessions (DISABLED). |
5. Choose the Extended tab page and enter the desired SQL user properties.
SQL User Properties
Extended |
Description |
Timeout |
You can set the timeout value. |
Cost Warning |
You can set the estimated SELECT cost value above which a warning is issued. |
Cost Limit |
You can set the estimated SELECT cost value above which an SQL statement is not executed. |
Default Code |
You can set a default value for the code attribute. |
Replication User |
Indicates whether the database user is the synchronization user |
See Conventions for User Names and Passwords.
You can change the SQL user properties of a database user. To do this, proceed as described in the following sections:
● Changing the SQL User Properties of a Database User
● Changing the Password of a Database User
You can delete database users.
...
1. Choose Instance ® Configuration ® Database User... .
2. Select the desired database user.
3. Choose Delete.
Choose one of the following options:
○ Default: The following are also deleted with the database user: all synonyms and tables that belong to this database user as well as all indexes, privileges, view tables, and so on, that are based on these synonyms and tables.
○ Restrict: The database user is deleted only if he or she does not have any synonyms or tables.
See also:
Concepts of the Database System, Database Users