Users Editor (Oracle)
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
- Open an editor on the user. For details, see Opening an Object Editor.
- Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
| Tab | Settings and tasks | |
|---|---|---|
|
Properties |
Lets you work with settings in the following categories: | |
|
Defaults |
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). | |
|
Account |
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. | |
|
Role |
Lets you select the roles that are to be assigned to this user. | |
|
Quota |
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. | |
|
Objects |
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.