I need to disable the "Grants on the user's objects for other user/roles" option in Schema browser | Users | Scripts tab | View/Edit settings, but when I do and apply this change, Toad hangs. I need to use Task Manager to close.
If I restart Toad, the setting is not changed or it still hangs when I go to the Script tab to change it again. How do I adjust this setting but not have Toad hang?
Possibly a conflict in the Toad.ini settings file.
WORKAROUND 1:
1. Go to Database | Export | DDL.
2. In the Object and Output tab, choose "Add" select what you want to create a script for.
3. Select a schema under "Schema to Search".
4. Select an object type in the next section. In this case, select "User" to create a user script. You can choose other options to filter a list of users.
5. Click the green arrow button in the upper left corner to search for the objects according to your settings.
6. Select a user or multiple uses from the list that is generated, and then click OK in the bottom right corner.
7. The chosen user(s) will be listed in the Object section of the "Objects and Output" tab.
8. Just below Object section, you can choose an output format in the Output section.
9. Go to the Script Options tab and disable the "Grants on the user's objects for other user/roles" option there. You can select/enable other options too.
10. Then click the green arrow icon at the top left corner again. This will run and create the script according to settings specified and output according to your output format selection.
This will also change the setting as if you were to go through Schema browser | Users | Scripts tab | View/Edit settings to adjust the options.
WORKAROUND 2:
1. Close out of Toad.
2. Go to the installation directory (C:\Program Files\Quest Software\Toad for Oracle9.5) and find the User Files folder.
3. Renamed Connectionpwds.ini and the Toad.ini files to back up the files.
4. Restart Toad, check issue, and resetting any personal Toad settings if needed.
This will force Toad to reset the Toad.ini file with default setting. You can revert back to the renamed files and previous setting if you need. You may need to re-enter in your personal setting changes if the newly generated Toad.ini resolved the issue with Toad hanging.
May be related to SOL37218 Schema browser | Users | Scripts tab is displaying Revokes and Grants only, or it is empty.
