The Users Folder

For more information about users, see the Oracle7 Server Concepts, the Oracle7 Server Administrator's Guide, and the Oracle7 Server SQL Reference.

The following figure illustrates the User object list.

Figure 4 - 1. User Object List

User Object List

Username	Name of the user.
Default Tablespace	Default tablespace for the user's objects.
Temp Tablespace	Tablespace for the user's temporary segments.
Profile	Profile assigned to the user.
Logged In	Whether or not the user is currently connected to the database.

Creating a User

The Create User property sheet consists of the following pages:

• General

• Quotas

• Privs & Roles (Privileges and Roles)

• Default Role

Figure 4 - 2. General Page of the Create User Property Sheet

Create User: General Page

Username	Name of the user to be created.
	Enter the name of the new user. The username can only contain characters from your database character set and can be at most 30 bytes long.
Password	Method Oracle uses to authenticate the user.
	Click OS Authenticated to specify that the operating system verify the user.
	Click Password to require a password for logon. Enter the password in the adjacent text entry field.
Default Tablespace	User's default tablespace.
	Use the pop-up menu to choose the default tablespace for objects the user creates.
Temporary Tablespace	User's tablespace for temporary segments.
	Use the pop-up menu to choose the tablespace for the user's temporary segments.
Profile	User's profile.
	Use the pop-up menu to assign a profile to the user.

Create User: Quotas Page

Figure 4 - 3. Quotas Page of the Create User Property Sheet

The Quotas page is described below:

Quotas	Scrolling list of the tablespace quotas assigned to the user.
Add	Displays the Add Quota dialog box, which allows you to specify a quota for the user. For a description of the Add Quota dialog box, see on page 4-5.
	When you have specified a quota, that quota appears in the Quotas scrolling list.
Edit	Displays the Edit Quota dialog box, which allows you to alter the quota selected in the Quotas scrolling list. For a description of the Edit Quota dialog box, see on page 4-6.
Remove	Removes the quota selected in the Quotas scrolling list.

Add Quota Dialog Box

Figure 4 - 4. Add Quota Dialog Box

The Add Quota dialog box is described below:

Tablespace	Tablespace to which the quota applies.
	Use the pop-up menu to specify the tablespace for the quota.
Quota Size	Maximum amount of space the user is allowed to allocate in the tablespace.
	To specify an unlimited quota for the tablespace, click the Unlimited button. With an unlimited quota, the user can allocate an unbounded amount of space in the tablespace.
	To specify a specific quota, click the quota size lower button and enter a quota value in the adjacent text entry field. Use the pop-up menu to specify kilobytes or megabytes.

Edit Quota Dialog Box

Figure 4 - 5. Edit Quota Dialog Box

The Edit Quota dialog box is described below:

Tablespace	Name of the tablespace for which you are changing the quota.
Quota Size	New quota size.
	The quota value is the maximum amount of space the user can allocate in the tablespace.
	To specify an unlimited quota for the tablespace, click Unlimited. With an unlimited quota, the user can allocate an unbounded amount of space in the tablespace.
	To specify a specific quota, click the quota size button and enter a quota value in the adjacent text entry field. Use the pop-up menu to specify kilobytes or megabytes.

Create User: Privileges and Roles Page

Figure 4 - 6. Privileges and Roles Page of the Create User Property Sheet

The Privileges and Roles page is described below:

Privileges and Roles	Scrolling list of the roles and privileges to be granted to the user.
Add	Displays the Add Privilege to User dialog box. See on page 4-8 for a description of the Add Privilege to User dialog box.
Remove	Removes the role or privilege selected in the Privileges and Roles scrolling list.

Add Privilege to User Dialog Box

The following figure illustrates the Add Privilege to User dialog box with the Role Privilege Type selected.

Figure 4 - 7. Add Privilege to User Dialog Box with the Role Privilege Type Selected

The Add Privilege to User dialog box in Figure 4-7 is described below:

Privilege Type: Role	Displays the roles you can grant to the user.
Defined Roles	Scrolling list of the roles you can grant. These are roles you have created and roles you have been granted with the Admin Option. If you have the GRANT ANY ROLE system privilege, all roles are listed.
	Select the role you wish to grant to the user.
Admin Option	Allows the user to grant the role to other users or roles. If you grant a role with the Admin Option, the user can also alter or drop the role.

The following figure illustrates the Add Privilege to User dialog box with the System Privilege Type selected.

Figure 4 - 8. Add Privilege to User Dialog Box with the System Privilege Type Selected

The Add Privilege to User dialog box in Figure 4-8 is described below:

Privilege Type: System	Displays the system privileges you can grant to the user.
System Privileges	Scrolling list of the system privileges you can grant. These are the system privileges you have been granted with the Admin Option. If you have the GRANT ANY PRIVILEGE system privilege, all privileges are listed.
	Select the system privilege you wish to grant to the user.
Admin Option	Allow the user to grant the system privilege to other users or roles.

The following figure illustrates the Add Privilege to User dialog box with the Object Privilege Type selected.

Figure 4 - 9. Add Privilege to User Dialog Box with the Object Privilege Type Selected

The Add Privilege to User dialog box in Figure 4-9 is described below:

Privilege Type: Object	Displays object privileges.
Object Privileges	Scrolling list of all object privileges.
	You can grant an object privilege that you have been granted with the Grant Option. If you are the owner of the object, you can grant all privileges on the object.
	The scrolling list includes the item ALL, which represents all object privileges you can grant on an object.
Object Name	Schema and name of the object on which you are granting privileges.
	Enter the schema and object name, or click Find Object.
Find Object	Displays the Find Schema Object dialog box. See on page 4-12 for a description of the Find Schema Object dialog box.
Admin Option	Allows the user to grant the object privilege to other users and roles.

Attention: In the SQL Worksheet, use the GRANT command to grant privileges on a column in a table or view. For information about the GRANT command, see the Oracle7 Server SQL Reference.

Find Schema Object Dialog Box

Figure 4 - 10. Find Schema Object Dialog Box

The Find Schema Object dialog box is described below:

Filters	Types of objects on which you can grant object privileges.
Click the object types you wish to find, then click Filter to find the objects.
Schema	Scrolling list of schemas in your database.
Select a schema from the Schema scrolling list. Server Manager retrieves all the objects in that schema that match the object types you chose in the Filters.
Object	Scrolling list of objects in the selected schema that match the object types you chose in the Filters.
Select the object on which you wish to grant object privileges.
Filter	Retrieves the objects in the selected schema that match the object types you chose in the Filters.

Create User: Default Role Page

Only a role granted directly to the user can be specified as a default role. A role granted through another role cannot be a default role.

The following figure illustrates the Default Role page.

Figure 4 - 11. Default Role Page of the Create User Property Sheet

The Default Role page is described below:

Default Roles	Scrolling list of the roles to be granted to the new user.
Select the roles you wish to designate as the user's default roles. Unlike most other scrolling lists in Server Manager, the Default Roles scrolling list allows you to make multiple selections.
All	Selects all roles in the Default Roles scrolling list.
Click All to make all roles granted to the user default roles.
None	Selects none of the roles in the Default Roles scrolling list.
Click None to make none of the roles granted to the user default roles.

Altering a User

The Alter User property sheet consists of the following pages:

• General

• Quotas

• Privs & Roles (Privileges and Roles)

• Default Role

• Objects

Figure 4 - 12. General Page of the Alter User Property Sheet

Alter User: General Page

Username	Name of the user to be altered.
Password	Method Oracle uses to authenticate the user.
	Click OS Authenticated to specify that the operating system verify the user.
	Click Password to require a password for logon. Enter the new password in the adjacent text entry field.
Default Tablespace	User's default tablespace.
	Use the pop-up menu to choose the new default tablespace for objects the user creates.
Temporary Tablespace	User's tablespace for temporary segments.
	Use the pop-up menu to choose the new tablespace for the user's temporary segments.
Profile	User's profile.
	Use the pop-up menu to assign a new profile to the user.

Alter User: Quotas Page

Figure 4 - 13. Quotas Page of the Alter User Property Sheet

The Quotas page is described below:

Quotas	Scrolling list of the quotas assigned to the user.
Add	Displays the Add Quota dialog box, which allows you to specify a quota for the user. For a description of the Add Quota dialog box, see on page 4-17.
Edit	Displays the Edit Quota dialog box, which allows you to alter the quota selected in the Quotas scrolling list. For a description of the Edit Quota dialog box, see on page 4-18.

Attention: To remove a quota you have assigned to a user, change the value of the quota to zero.

Add Quota Dialog Box

Figure 4 - 14. Add Quota Dialog Box

The Add Quota dialog box is described below:

Tablespace	Tablespace to which the quota applies.
	Use the pop-up menu to specify the tablespace for the quota.
Quota Size	Maximum amount of space the user is allowed to allocate in the tablespace.
	To specify an unlimited quota for the tablespace, click the Unlimited button. With an unlimited quota, the user can allocate an unbounded amount of space in the tablespace.
	To specify a specific quota, click the quota size lower button and enter a quota value in the adjacent text entry field. Use the pop-up menu to specify kilobytes or megabytes.

Edit Quota Dialog Box

Figure 4 - 15. Edit Quota Dialog Box

The Edit Quota dialog box is described below:

Tablespace	Name of the tablespace for which you are changing the quota.
Quota Size	New quota size.
	The quota value is the maximum amount of space the user can allocate in the tablespace.
	To specify an unlimited quota for the tablespace, click Unlimited. With an unlimited quota, the user can allocate an unbounded amount of space in the tablespace.
	To specify a specific quota, click the quota size button and enter a quota value in the adjacent text entry field. Use the pop-up menu to specify kilobytes or megabytes.

Alter User: Privileges and Roles Page

Figure 4 - 16. Privileges and Roles Page of the Alter User Property Sheet

The Privileges and Roles page is described below:

Privileges and Roles	Scrolling list of the roles and privileges assigned to the user.
Add	Displays the Add Privilege to User dialog box. See on page 4-8 for a description of the Add Privilege to User dialog box.
Remove	Removes the role or privilege selected in the Privileges and Roles scrolling list.

Alter User: Default Role Page

Only a role granted directly to the user can be specified as a default role. A role granted through another role cannot be a default role.

The following figure illustrates the Default Role page.

Figure 4 - 17. Default Role Page of the Alter User Property Sheet

The Default Role page is described below:

Default Roles	Scrolling list of all of the roles granted to the user.
Select the roles you wish to designate as the user's default roles. Unlike most other scrolling lists in Server Manager, the Default Roles scrolling list allows you to make multiple selections.

Note: Roles assigned as default roles appear selected. Unselected roles are not default roles for this user and need to be activated explicitly by the user after connecting to the database.

All	Selects all roles in the Default Roles scrolling list.
Click All to make all roles granted to the user default roles.
None	Selects none of the roles in the Default Roles scrolling list.
Click None to make none of the roles granted to the user default roles.

Alter User: Objects Page

Figure 4 - 18. Objects Page of the Alter User Property Sheet

Dropping a User

The following figure illustrates the Drop User alert box.

Figure 4 - 19. Drop User Alert Box

The Drop User alert box indicates if the user still owns any objects.

If you drop a user who owns objects, Server Manager:

• drops all of the objects in the user's schema

• drops any referential integrity constraints in other schemas that refer to the dropped user's tables

• invalidates any views or synonyms for objects in the dropped user's schema

• invalidates any stored procedures, functions, or packages that query objects in the dropped user's schema

• does not drop snapshots on tables or views in the dropped user's schema

• does not drop any roles created by the user

Adding a Privilege to or Removing a Privilege from a User

To remove a privilege from a user, select the user from the User object list and choose Remove Privilege from User from the User menu. The Remove Privilege from User dialog box appears.

The following figure illustrates the Remove Privilege from User dialog box.

Figure 4 - 20. Remove Privilege from User Dialog Box

The Remove Privilege dialog box is described below:

Privileges and Roles	Scrolling list of the privileges and roles assigned to the user.
	Select the role or privilege you wish to revoke from the user.

Disconnecting a User

The following figure illustrates the Disconnect User alert box.

Figure 4 - 21. Disconnect User Alert Box

The Disconnect menu item in the User menu disconnects all sessions for the user. If you wish to disconnect a specific session, use the Sessions folder in the Instance drawer. For information about disconnecting a session from the Sessions folder, see "Disconnecting a User's Session" .

Attention: When you disconnect a session, the session is not actually terminated until the user tries to execute a database operation. In the User object list, the user continues to be listed as logged in until the user tries to executes a database operation.