Though the user is not given create job privilege, it can still create jobs through dbms_job. how to disable dbms_job to user or not allow user using this package to create/alter/drop job. what would be the revoke statement used?
What is you Database Version Check this link may it help you :ORACLE-BASE - Basic Security Measures for Oracle
Hi Karthik, If you were using 10.2.0.1.0, probably, the statement SQL> REVOKE EXECUTE ON dbms_job FROM PUBLIC to be executed,...,
Revoke execute on dbms_job from public;
Thanks All for your reply, that helps.