Re: Permsssions to create sql profiles

From: <zigzagdna_at_yahoo.com>
Date: Tue, 10 Feb 2009 08:25:30 -0800 (PST)
Message-ID: <a265288e-ae71-4e41-a0a7-a9a6070047d3_at_v19g2000yqn.googlegroups.com>

On Feb 5, 5:23 pm, zigzag..._at_yahoo.com wrote:
> On Feb 5, 5:02 pm, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
>
>
>
>
>
> > 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.
>
> Charles:
> Thanks a lot. I think to run dbms_sqltune  one needs dba privleges
> (advsior role is not enough). Then to accept profiles etc one needs
> create, drop and alter privileges.- Hide quoted text -
>
> - Show quoted text -

I found a combination of adcisor role and create. drop and alter privileges on sql profile works. I did not need dba privileges. Received on Tue Feb 10 2009 - 10:25:30 CST