We have users with 1000's of grants. When we clone 1 of these, we have to wait forever for the clone to process all of these statements. Can we have an option to run it in the background so we can do other work in Toad?
For consistency, how about a "show sql" button? Then you could send to editor and run in QSR or SQL*Plus.
Users with thousands of grants. Hmmm. These must be object grants instead of role grants since there is a maximum limit of 148 role grants (MAX_ENABLED_ROLES). It is usually the practice to grant objects to roles and roles to users. Doing that may simplify your work.
Cheers,
Russ
(Note: I am not affiliated with Quest.)
1 Like
We've added "Show SQL" button. Will be included with next Beta version.