When attempting to modify the SCHEMA ADM permission for a role via the Explorer | Alter Role, the option doesn't select and is ignored.
========================
1. Create the necessary objects:
CREATE ROLE TESTROLE;
CREATE SCHEMA SAMPLE;
2. In the explorer navigate to "Security" section, select "Roles"
3. Right-click on the role you created (TESTROLE) and choose "Alter Role"
4. Select the "Schema" tab and add a new schema (SAMPLE) or select an existing one.
5. Attempt to modify permissions:
To change the schema wide SELECT permission, select the green checkmark from the combo box selection under SELECT IN. This action is successful, and a correct script is generated.
However, when attempting to modify the SCHEMA ADM permission, the green checkmark can be selected, but the window immediately reverts to its original state, discarding the change. Consequently, no script is generated for this permission change.
Expected Behavior: The SCHEMA ADM permission should be modifiable like the SELECT permission, allowing changes to be saved and a script to be generated.
Actual Behavior: The SCHEMA ADM permission reverts back immediately after selection, preventing any modification, and no script is generated.
========================
WORKAROUND:
Press the green tick to select all roles, and then untick the roles you don’t want
STATUS:
Waiting for fix in a future release of Toad for DB2
