Toad for Oracle 10.0.0.41
Toad for Oracle Professional Add-Ons: DB Admin Module
Select two users in “Schema Browser”.
Right click and select “Create Script”.
Highlight both users.
Output to “Editor - as script”.
Script Options > Users > select “Grants on the users’s objects to other users/roles”.
The script created in the editor window is not correct. It duplicates the grants for one schema and only sometimes includes the grants for the other schema(s).
If you output to clipboard you get the same wrong result. Output to a file and you only get one users script.
Anyone seen this? Any solutions?