RE: Grant-execute-on-DBMS-SYSTEM

  • From: Jimmy Brock <jimmybrock@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Sun, 8 May 2011 05:03:48 -0700

Since the DBMS_SYSTEM package is undocumented I would be cautious about
granting privileges to it.

I have granted access to it in the past to a user/schema that needed it to
write messages and timestamps to a trace file. The schema contained an
instrumentation package for measuring PL/SQL tasks using extended tracing.
But I only granted execute privileges to DBMS_SYSTEM in the development
environment, not in testing or production.


-- 
Jimmy Brock

Other related posts:

  • » RE: Grant-execute-on-DBMS-SYSTEM - Jimmy Brock