Editing an Existing Database User

Previous

Next

---

To edit an existing user account:

1. On the Database Home Page, click the Administration icon and then Database Users.

2. If prompted, enter the appropriate administrator username and password and click Login.

   The Manage Database Users page appears.

   Use the fields and buttons at the top of the page to search for a specific user or alter the page view. See "Viewing Database Users".

3. To edit account details, select a user.

   The User page appears.

4. To edit a user's password:

   1. Password- Enter a password for database authentication.

   2. Confirm Password - Enter the password again.

5. Select Expire Password to prompt users to change their password the next time they log in.

6. Use Account Status to control whether a user can log into the account. Valid options include:

   • Unlocked. Select this option to enable a user to log in.

   • Locked. Select this option to prevent a user from logging in.

   Use Roles to specify a group of related database privileges for this user.

7. Under Roles, select the appropriate role:

   • CONNECT - Enables a user to connect to the database and perform basic database actions. Assign this role to any user or application that needs database access. CONNECT includes the system privilege CREATE SESSION.

   • RESOURCE - Enables a user to create schema objects. Assign this role only to developers and power users. RESOURCE includes the following system privileges: CREATE CLUSTER, CREATE INDEXTYPE, CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER, and CREATE TYPE.

   • DBA - Enables a user to access the database objects of all other users and administer the database. Does not include the privileges to start up or shut down the database. DBA includes the system privilege WITH ADMIN OPTION.

   To have more control over the privileges assigned to a user, you can create your own roles or augment the selected roles by selecting additional privilege.

8. Under Directly Grant Privileges, select additional privileges for the user. To select all privileges, click Check All. To deselect all privileges, click Uncheck All.

   Note that you can manage additional user attributes using SQL Commands. See "Using SQL Commands".

9. To view current system privileges granted to the current user, click All System Privileges Granted to at the bottom of the page.

   A report appears.

10. Click Alter User.