I have had to revoke rights from public for IRS 1075 compliance. I tested applications and gave rights to individual users or roles. But I just discovered I cannot do an explain in toad’s editor now when I’m logged in as system. I can however see it if I’m logged in as sys. What rights do I need to grant to the system views or roles that public once had so I can do explains again?
what is the error that you get when you try to do the explain plan?
In Toad, you can probably solve this by going to Options -> Oracle -> General, then click the ‘…’ button next to “plan table” and either choose or create a plan table that SYSTEM has privileges to use.