How to disable compilation of objects based on profile

You can use the Authorization function for this. It allows you to explicitly grant various PL/SQL Developer features based on the user or role. See chapter 30 in the User's Guide for more details.

It is however always best to use Oracle database privileges.
 
Back
Top