Re: Permsssions to create sql profiles
Date: Thu, 5 Feb 2009 14:02:00 -0800 (PST)
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
> 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).
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Thu Feb 05 2009 - 16:02:00 CST