RE: Grant-execute-on-DBMS-SYSTEM

From: Jimmy Brock <jimmybrock_at_gmail.com>
Date: Sun, 8 May 2011 05:03:48 -0700
Message-ID: <BANLkTinG07+Ss+P6Xes7j4MxXv7x=-nNgQ_at_mail.gmail.com>

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

--

http://www.freelists.org/webpage/oracle-l Received on Sun May 08 2011 - 07:03:48 CDT