Can I lock TOAD schema & remove it's roles and still have the explain plan working?
Certain shops are concern about the security issue with TOAD schema that is created via Server side objects.
You can lock TOAD schema during the set up of Server side objects or at a later time. You can also revoke both "Connect" and "Resource" roles from TOAD schema and the explain plan will still work for other users.
This is true for EXPLAIN PLAN function only, other features set up by the server side objects have not been tested to work without the granted roles.