Users Wizard (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Wizards

Whoever you add as a user will have access to the Oracle database. You also can set up the means by which the database recognizes the user.

Important Notes

  • To create a user, you need the CREATE USER system privilege.

To create a new user using a wizard:

  1. Open a creation wizard for a user. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. Finally, use the Execute button to create the object.

Users (Oracle) - Properties

When creating or editing a user, this tab/panel lets you work with the following settings:

Setting Description


Provide a name for the user.

Default Tablespace and Temporary Tablespace

Select the default tablespace for objects the user creates and the tablespace to be used for the user’s temporary segments. If you do not specify a default tablespace when creating a user, the assigned tablespace will be that set using the Set Default function. For details, see Set Default.


The profile you choose affects the amount of database resources available to the user.

Identified By

REQUIRED_YES - A user identified by password is a local user. REQUIRED_EXTERNAL - This is a user who is validated by an external service like an operating system or third-party service. The login authentication is handled by that external entity. REQUIRED_GLOBAL - The user you’re creating is a global user who is authenticated by the enterprise directory service.


If you specified an Identified By value of REQUIRED_YES, provide a password for the user.

External Name

If you specified an Identified By value of REQUIRED_EXTERNAL, provide an external name for the user.

Account Locked

When enabled, the account cannot be altered by anyone but the creator. It also means that after a specified number of failed attempts to access the database, the database will remain closed to the user for a period of time.

Password Expired

Marks the password as expired, forcing the user to change the password before being allowed to connect to the database.

Users (Oracle) - Roles

For each role to be assigned to the user, select the check box beside that role.

Users (Oracle) - Quotas

To assign a tablespace quota for a user, select a tablespace, select the Other radio button, and provide the value in the Quota box.