When using Alter User window, the column for the Default check boxes in the roles tab disappear after viewing the Create Role window (roles tab).
When you go into Alter User, under the role tab you see columns for Granted, Admin, Default checkboxes for each role. Exit this window, go to Database | Create | Role. There is no Default column (this is expected). Close the create role window and go back to alter user window, under the role tab again. But this time you'll see that the Default column is no longer visible (this is not expected).
You have to click the top left corner to select which columns to show and select to show the default column. If you don't go into the create role window, this does column setting to show or hide default column does not change.
WORKAROUND:
Use the setting to show or hide columns in the top left corner of the grid in Roles tab (Alter User window). Select to display Default column. See screen shot SOL67568_Fig1.JPG.
STATUS:
Waiting for fix in a future version of Toad for Oracle.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center