Oracle Database Discussions

HI ALL,

The below statement is used to compile apps schema.

DBMS_UTILITY.COMPILE_SCHEMA('APPS',FALSE);

But the problem is this is getting executed from all schema .

Suppose if iam creating a new user 'Newusr'. The above statment is also getting executed from the Newusr schema.

This needs to be restricted in the way that the schema can compile one its object. For example using this

Dbms_utility.compile_schema if i want to compile apps user then i should have been logged as a apps user. No other

user should have a privilege to compile apps schema objects using dbms_utility.



Reason :

This DBMS_UTILITY package belongs to sys user and its respective synonym is available in public schema and this public schema is having execute privilege over dbms_utility package.

i hope because of this all the user are able to compile any schema objects using this package dbms_utility.


1)So i need to know instead of revoking execute permission from public user for entire dbms_utility package. Is there is any way to revoke only(complie procedure) dbms_utililty.compile_schema...

2)Are any other way to restrict users not compile other schema objects using dbms_utility.