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

Home » Misc » Here

Comments

Basic Security Measures for Oracle - This article presents some basic steps to increase the security of your Oracle database servers.



kuljeet said...

Hi,

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

Thanks
Kuljeet Pal Singh
ks_johar@hotmail.com



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!

Cheers

Tim...

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!