'Configuring grantees' feature under the Roles tab is not setting to default (4284696)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

'Configuring grantees' feature under the Roles tab is not setting to default
Description

In Toad v10.5.0.41, the 'Configuring grantees' feature under the Roles tab is not setting to default. This is not a problem with v9.7.2.5. Also, this happens for SYS schema too. So, it can't be rights related.
1. Go to the Role tab
2. Select a Role
3. Right click and select "Configure grantees"
4. Check "Default" and click OK
5. Open "Configure grantees" again and you'll see that default is still un-checked
Resolution

WORKAROUND:
1. Click on 'Show SQLL' and then 'Send to Editor'
2. In the Editor, add the line

DEFAULT ROLE "<ROLE_NAME>";
Â
STATUS:
Waiting for fix in a future release of Toad for Oracle.
Defect ID

ST73756
Additional Information

If you look at the SQL generated, it is missing the correct user in the statement
DEFAULT ROLE "<USER>";
Â

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title