Example: Creating a User Account

You can use Oracle Enterprise Manager Database Express (EM Express) to create a user account in a pluggable database (PDB) for a database application developer named Nick. Because Nick is a developer, you want to grant him the database privileges and roles that he requires to build and test his applications. You also want to give Nick a 16 MB quota on his default tablespace so that he can create schema objects in that tablespace.

To create the user Nick:

  1. In EM Express, go to the Users page, as described in "Viewing User Accounts".

  2. On the Users page, click Create User.

    The Create User wizard appears, showing the User Account page.

  3. Enter the following values:

    • In the Name field, enter NICK.

    • Accept the default value Password in the Authentication list.

      For information about other more advanced methods to authenticate users, see Oracle Database Security Guide.

    • In the Password and Confirm Password fields, enter a secure password for user Nick.

      See Oracle Database Security Guide for more information about secure passwords.

    • In the Profile list, accept the value DEFAULT.

      This setting assigns the default password policy to user Nick.

      See "Setting the Database Password Policy".

    • Enable the Password Expired option. When this option is enabled at user creation time, then the user must create a new password the first time he logs into his account.

    • Do not select Account Locked.

      You can lock the user account later to prevent users from logging in with it. To temporarily deny access to a user account, locking the user account is preferable to deleting it, because deleting it also deletes all schema objects owned by the user.

  4. Click the right arrow button.

    The Tablespaces page appears.

  5. Enter the following values:

    • For the Default Tablespace field, select the USERS tablespace.

      All schema objects that Nick creates will then be created in the USERS tablespace unless he specifies otherwise. If you leave the Default Tablespace field blank, then Nick is assigned the default tablespace for the database, which is USERS in a newly installed database. For more information about the USERS tablespace, see "About Tablespaces".

    • For the Temporary Tablespace field, select the TEMP tablespace.

      If you leave the Temporary Tablespace field blank, then Nick is assigned the default temporary tablespace for the database, which is TEMP in a newly installed database. For more information about the TEMP tablespace, see "About Tablespaces".

  6. Click the right arrow button.

    The Privilege page appears.

  7. Grant roles, system privileges, and object privileges to the user, as described in "Example: Granting Privileges and Roles to a User Account".

  8. Assign a 16 MB quota on the USERS tablespace, as described in "Example: Assigning a Tablespace Quota to a User Account".