Skip to content
pvmehta.com

pvmehta.com

  • Home
  • About Me
  • Toggle search form
  • send email from unix mailx with attachment. Linux/Unix
  • Explain Plan Doesn’T Change For Sql After New Statistics Generated Oracle
  • alter database backup controlfile to trace Oracle
  • Insert cause enqueue locks Oracle
  • V$ROLLSTAT status is Full Oracle
  • Rename Oracle Instance Name Oracle
  • compile_inv.sql Oracle
  • Passing from Unix to PLSQL using bind variables Linux/Unix
  • telnet listening Linux/Unix
  • Kernel Parameter setting explaination for Processes Parameter Linux/Unix
  • Monitor Long Running Job Oracle
  • purge_trc.sh Linux/Unix
  • replacing ^M character when passing files from Windows to Unix Linux/Unix
  • Looping for remote servers and find its database from oratab file. Linux/Unix
  • Resolving RMAN Hung Jobs 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

  • Generating XML from SQLPLUS Oracle
  • Good RAC & Standby Notes Oracle
  • Oracle Internal Good Websites 1 Oracle
  • Good Link from metalink 1 Oracle
  • Vivek Tuning for Row Locks. Oracle
  • Find_table_size.sql 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 (388)
  • PHP/MYSQL/Wordpress (10)
  • Power-BI (0)
  • Python/PySpark (7)
  • RAC (17)
  • rman-dataguard (26)
  • shell (149)
  • SQL scripts (337)
  • Uncategorized (0)
  • Videos (0)

Recent Posts

  • 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
  • Reading config file from other folder inside class24-Sep-2024
  • Python class import from different folders22-Sep-2024
  • Transfer SQL Profiles from One database to other database.05-Sep-2024
  • Load testing on Oracle 19C RAC with HammerDB18-Jan-2024

Archives

  • 2025
  • 2024
  • 2023
  • 2010
  • 2009
  • 2008
  • 2007
  • 2006
  • 2005
  • Parallel DML Oracle
  • login.sql Oracle
  • pvmehta.com SQL scripts
    Find which sessions is accessing object that prevent your session to have exclusive locks in Oracle Oracle
  • 339939.1 Running Cluster Verification Utility to Diagnose Install Problems Oracle
  • Find_stale_dr.sql finding stale physical DR.. Oracle
  • initUOCIOTTO.ora Oracle
  • New OFA for 11g Oracle
  • segment_wise_space.sql segspace.sql Segment wise space usage (allocated and used) Oracle

Copyright © 2025 pvmehta.com.

Powered by PressBook News WordPress theme