Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Security and revoking UTL_SMTP, DBMS_SQL etc from PUBLIC

697698Jun 18 2009 — edited Jun 18 2009

We have been tasked via a security audit to revoke execute on various PL/SQL packages (such as UTL_SMTP, UTL_TCP, UTL_FILE, DBMS_RANDOM, DBMS_LOB, DBMS_SQL) from PUBLIC. I believe there are a great number of dependencies that could cause destructive consequences in the database if this is done.

Is this true and if so is there a way to stop users (other than admin type users) from having use of these procedures?

Thanks
Greg

This post has been answered by Srini Chavali-Oracle on Jun 18 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 16 2009

Added on Jun 18 2009

#general-database-discussions

2 comments

649 views