1 Reply Latest reply: Jul 31, 2012 2:46 PM by HG75 RSS

    DEBUG ANY PROCEDURE

    Brian Bontrager
      Oracle 9.2.0.6, soon to be 11.1.0.7...

      Please double-check my understanding of the documentation.

      We have at least one developer who likes to use the PL/SQL Debugger functionality, which requires DEBUG ANY PROCEDURE (http://docs.oracle.com/cd/B10501_01/appdev.920/a96590/adg10pck.htm#37819).

      Our system DBAs are wisely hesitant in granting an "ANY" privilege. My understanding is that even though this privilege has "ANY" in the name, it is not highly privileged like ALTER ANY TABLE, EXECUTE ANY PROCEDURE, etc.

      Should I (or the system DBAs) have any reservation with this privilege in development and test environments?


      The SQL reference notes that it is equivalent to granting DEBUG on every applicable object. (http://docs.oracle.com/cd/B10501_01/server.920/a96540/statements_912a.htm#2075179).

      If I read this right, and if a DBA will not grant DEBUG ANY PROCEDURE, I should be able to grant DEBUG on each PL/SQL object to the developer to get the same result?

      Thanks