Before You Begin

This 10-minute tutorial shows you how to use Enterprise Manager Express to administer database user accounts and security.

Select the Oracle Database release:

Background

When you create a user account, you must assign a user name, a password, and default tablespaces for the account. You must also grant the appropriate system privileges, object privileges, and roles to the user account. If the user will create database objects, assign a space usage quota for each affected tablespace.

What Do You Need?

• Oracle Database 18c19c

View User Accounts

1. Enter the URL for the Enterprise Manager Database Express for PDB in your browser and log in as the SYSTEM user.

   

2. Select Users in the Security menu.

   

   Note: If you log in as the Enterprise Manager Database Express for CDB, you will not see Profiles in the Security menu.
3. The Users page is displayed.

   

4. To view additional information about the user, select the user. Expand the Actions menu and select View Details. In this example, the HR user is selected.

   

5. Privileges and roles granted to the user are displayed.

   

6. Click ORCL / ORCLPDB to return to the Database Home page.

Create a User Account

1. Select Users in the Security menu.

   

2. Click Create User on the Users page.

   

3. Enter a user name such as appuser in the Name field. Enter a password in the Password field and in the Confirm Password field. Accept the Profile default value of DEFAULT. Click the right arrow. 

   

4. Select the APPTS tablespace or another tablespace of your choice. Accept the default TEMP temporary tablespace. Click the right arrow.

   

5. Select the APPDEV role and select With Admin. Click OK.

   

6. Click OK on the Confirmation page. The new APPUSER user is listed on the Users page.

   

7. Click ORCL / ORCLPDB to return to the Database Home page.

Unlock a User Account

1. Select Users in the Security menu.

   

2. Select the HR user. Select Alter Account in the Actions menu.

   

3. Deselect Account Locked. Click OK.

   

4. Click OK on the Confirmation page. The Account Status for the HR user indicates the user is unlocked.

   

5. Click ORCL / ORCLPDB to return to the Database Home page.