Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • find_err.sql for finding errors from dba_errors. Oracle
  • scripts to take listener.log backup Linux/Unix
  • Clean up Oracle
  • configUOCIOTTO.ora Oracle
  • Locally Managed Tablespace and Dictionary managed tablespace (LMT-DMT) Oracle
  • How to find Unix server conguraiton including Server Model number and underlying disk sub-system ( On Solaris) Linux/Unix
  • v$backup.status information Oracle
  • RAC 11g with vmware Oracle
  • DBA_HIST_SQLSTAT contents Oracle
  • Find Plan Hash value fphv.sql Oracle
  • sid_wise_cursor.sql find open cursor basis on username or SID Oracle
  • Follwoing korn shell is used to move files from source folder to destination folder and gzip it in destination folder. mv_iotto.ksh Linux/Unix
  • find_log_switch.sql Find log switches in graphical manner Oracle
  • Important Solaris Commands Linux/Unix
  • useful dg links Oracle

Alter procedure auditing

Posted on 28-Jul-2009 By Admin No Comments on Alter procedure auditing

A common misconception is that the ‘audit any procedure’ is a privileges auditing option associated with the privilege ‘alter

any procedure’ and thus does NOT cover the alteration of a procedure that is

owned by the user altering it.

Note that AUDIT PROCEDURE covers:

CREATE FUNCTION

CREATE LIBRARY

CREATE PACKAGE

CREATE PACKAGE BODY

CREATE PROCEDURE

DROP FUNCTION

DROP LIBRARY

DROP PACKAGE

DROP PROCEDURE

Also Object Auditing Options ‘ALTER’ does not apply to Procedure, Function, Package, so

even object auditing can’t cover this.

I think otherwise every implicit recompilation would trigger an undesired audit record.

There’s no corresponding Statement auditing option available for ALTER PROCEDURE

either,

it looks like this was not implemented for some reason.

Oracle, SQL scripts

Post navigation

Previous Post: EXTPROC
Next Post: New OFA for 11g

Related Posts

  • DBMS_JOB all example Oracle
  • How to know current SID Oracle
  • Jai Shree Ram Oracle
  • Find_planinfo.sql Oracle
  • ORA-8031 issue and solution if it is occuring due to truncate. Oracle
  • Load SPM baseline from AWR Oracle

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Categories

  • AWS (2)
  • Azure (1)
  • Linux/Unix (149)
  • Oracle (392)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (341)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • load SPM baseline from cursor cache05-Jun-2025
  • Drop all SPM baselines for SQL handle05-Jun-2025
  • Load SPM baseline from AWR05-Jun-2025
  • Drop specific SQL plan baseline – spm05-Jun-2025
  • findinfo.sql (SQL for getting CPU and Active session info)27-May-2025
  • SQL Tracker by SID sqltrackerbysid.sql22-Apr-2025
  • How to connect to Oracle Database with Wallet with Python.21-Mar-2025
  • JSON/XML Types in Oracle18-Mar-2025
  • CPU Core related projections12-Mar-2025
  • Exadata Basics10-Dec-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Proc Compilation Oracle
  • crtgr.sql /* For creating trigger from data dictionary */ Oracle
  • How To Transfer Passwords Between Databases (ref note: 199582.1) Oracle
  • Deleting first line and lastline of a file using sed Linux/Unix
  • Good Doc 28-JUN-2006 Oracle
  • configUOCIOTTO.ora Oracle
  • All About oracle password and security from metalink Oracle
  • find the files that are 1 day old. Linux/Unix

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme