-
Title
"Script is empty!" message given when trying to set "Initial" in "Resource Groups" when altering -
Description
When altering an oracle user on the "Resource Groups" tab, clicking the "Initial" checkbox for a resource group then pressing "OK" resulting in "Script is empty!" message.
Pressing "Show SQL" results in a "There is no script to copy" message. -
Cause
The "Switch" checkbox is not checked.
-
Resolution
Check the "Switch" checkbox also when trying to set "Initial".
-
Additional Information
Resource Groups tab
Click the Resource Groups tab to add or modify resource groups for the selected or new user.
A list of available groups is displayed on the left of the page. To the right are check boxes to select permissions to those groups as follows:
Switch
Switch grants permission to switch to that resource group during a session.
Initial Group
This is the group that the user is a part of when he first connects to the database. When the connection is established, the user can switch to any other resource group included in his "switch" list.
Note: Only one initial group is permissible for a single user.
Admin
A user with the Admin permission can grant the switch privilege for that group to other users.