Re: Permsssions to create sql profiles
From: <zigzagdna_at_yahoo.com>
Date: Thu, 5 Feb 2009 14:23:15 -0800 (PST)
Message-ID: <16ac6ddf-910a-4a73-bd0b-850c3908514a_at_t26g2000prh.googlegroups.com>
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.
Date: Thu, 5 Feb 2009 14:23:15 -0800 (PST)
Message-ID: <16ac6ddf-910a-4a73-bd0b-850c3908514a_at_t26g2000prh.googlegroups.com>
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.
Received on Thu Feb 05 2009 - 16:23:15 CST