8i | 9i | 10g | 11g | 12c | Misc | PL/SQL | SQL | RAC | Linux

Home » Misc » Here

Comments for Basic Security Measures for Oracle

kuljeet said...


Don't revoke privilege on dbms_job from public by REVOKE EXECUTE ON dbms_java FROm public;

if ur using export backup by system then u will get ORA-00904 error
after revoking privilege from public.

Solution :-
grant execute privilege to system on dbms_java or
don't revoke it from public

Kuljeet Pal Singh

Tim... said...

Sorry, I don't understand. You can't revoke access to DBMS_JOB by revoking privileges on DBMS_JAVA!

The contents of this article are a summarization of recommendations by Oracle!



DO NOT ask technical questions here! They will be deleted!

These comments should relate to the contents of a specific article. Constructive criticism is good. Advertising and offensive comments are bad and will be deleted!