Re: Permsssions to create sql profiles

From: Charles Hooper <hooperc2000_at_yahoo.com>
Date: Thu, 5 Feb 2009 14:02:00 -0800 (PST)
Message-ID: <2a5e51c0-bc5a-41ae-8067-ac5ebe0338d0_at_y38g2000prg.googlegroups.com>



On Feb 5, 4:45 pm, zigzag..._at_yahoo.com wrote:
> I am using Oracle 10.1 and 10.2 on Windows 2003 and HP UNIX 11i
> platforms.
> When I need to create sql profiles, it works if I login with dba
> privileges. However, for some databases I do not have dba privileges.
> What are minimum privileges required. I read somewhere to be given
> advisor role. But, advisor role still gives some access errors.
> I know with stored outlines one did not need dba privileges; it should
> be true with sql profile as well.

Page 275 of "Troubleshooting Oracle Performance" states that you will need:

* create any sql profile
* drop any sql profile
* alter any sql profile

In 11g, just the following is needed:
* administer sql management object

Side note: make certain that you have an appropriate license to access the SQL Tuning Advisor (uses dbms_sqltune).

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Thu Feb 05 2009 - 16:02:00 CST

Original text of this message