Users Editor (Oracle)

From DBArtisan
Jump to: navigation, search

Go Up to Oracle Object Editors

The Users Editor lets you manage basic properties, roles, tablespace quotas, and associated objects for a user.

To edit a user

  1. Open an editor on the user. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Lets you work with settings in the following categories:


Lets you select a Default Tablespace and Temporary Tablespace as well as select the Profile used by this user. For more on creating profiles, see Profiles Wizard (Oracle).


Identified By - Lets you select among REQUIRED YES, REQUIRED EXTERNAL, and REQUIRED_GLOBAL. Password - (available with Identified By value of REQUIRED_YES only) lets you specify a password. External Name - (available with Identified By value of REQUIRED_GLOBAL only) lets you specify the name of the user in the enterprise directory service. Account Locked - lets you lock this user account. Password Expired - (available with Identified By value of REQUIRED_YES only) lets you mark the password as expired, forcing the user to change their password before being allowed to connect.


Lets you select the roles that are to be assigned to this user.


Lets you set tablespace quotas for the user. Set an unlimited quota by selecting a tablespace and selecting the Unlimited radio button. Set a specific quota by selecting a tablespace, selecting the Other radio button, and providing a Quota value in kilobytes or megabytes.


Lets you manage database objects associated with a user. Objects are grouped within object type folders. Optionally, you can:

Select an object and click Edit to open an object editor on the selected object.

Select an object and click Drop to initiate dropping the selected object.

Object Privileges and System Privileges

For details on using these tabs, see Working with Privileges and Permissions.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.