<< Click to Display Table of Contents >>

Overview Users

Top Previous Next

Overview Users is the default sheet. It displays a list of all users in the database:

User name

User ID

Time stamp of creation

Default tablespace name

Temporary tablespace name

Resource profile name

Can the user connect with SYSDBA privileges ?

Can the user connect with SYSOPER privileges ?

 

frmUsers_Overview

 

The following context operations are available:

UsersCreate

Create

Shows a modal dialog for creating a new user. It appears with defaults gathered from the currently selected user.

07_Drop

Drop

Drops the selected user(s). You can check the Cascade option in the modal dialog to drop a user and all of his objects.

05_Properties

Properties/Alter

Shows a modal dialog for viewing and modifying properties of the user, including password, tablespaces, and profile.

 

Initial Consumer Group

Shows the Switch Consumer Group dialog, which allows switching the user to another Consumer Group,assuming that the connected user has this privilege.

Password

Change Password

Shows a modal dialog for changing the password of the selected account.

 

Expire Password

Forces users to choose a new password the first time that they log in

 

Show DDL

Shows DDL to create this user with current privileges.

DISABLE

Lock account

Locks the selected account.

ENABLE

Unlock account

Unlocks the selected account.

 

Grid View

For more information, see object window