40376 User script tab shows wrong default role. DEFAULT ROLE ALL incorrectly used by Toad. (4328461)

40376 User script tab shows wrong default role. DEFAULT ROLE ALL incorrectly used by Toad.

I assigned a user a default role, then check the Schema Browser | User | Script tab for the user and it shows the user default role is 'ALL', and not the default role assigned. For a user that has Oracle's "default role all", when adding a role to the user account, the new role is not being applied on login

Steps to replicate:
1. Create a test role called TEST_DEVELOPER_ROLE.

2. Run the script below in the Editor window:
CREATE USER TEST
IDENTIFIED BY VALUES 'TEST'
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 1 Role for TEST
GRANT TEST_DEVELOPER_ROLE TO TEST;
ALTER USER TEST DEFAULT ROLE TEST_DEVELOPER_ROLE ;

3. Now go to Schema Browser | User | Script tab and it will show the script as:
CREATE USER TEST
IDENTIFIED BY VALUES 'TEST'
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 1 Role for TEST
GRANT TEST_DEVELOPER_ROLE TO TEST;
ALTER USER TEST DEFAULT ROLE ALL ;


Toad for Oracle 9.5.0 changed the role from TEST_DEVELOPER_ROLE to ALL.

If "default role all" is set, any subsequent role(s) granted to the account will be enabled and set as default role. But it is not doing for the user/schema, even though Toad script reflects the setting "default role all". This is misleading.

 

WORKAROUND:
None

STATUS:
Waiting for fix in future release of Toad for Oracle.