How to disable compilation of objects based on profile

[rkhan]

Hi,
Is there a way to disable compilation of objects based on profile?
Thnx
Rizwan

 

[Marco Kalter]

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.