Users Wizard (Oracle)
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:
- Open a creation wizard for a user. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see Users (Oracle) - Properties.
- Roles panel - for details, see Users (Oracle) - Roles.
- Quotas panel - for details, see Users (Oracle) - Quotas.
- DDL panel - for details, see Previewing the DDL Generated to Create the New Object.
- 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 |
---|---|
Name |
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. |
Profile |
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. |
Password |
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.