Re: Permsssions to create sql profiles
- From: zigzagdna@xxxxxxxxx
- Date: Tue, 10 Feb 2009 08:25:30 -0800 (PST)
On Feb 5, 5:23 pm, zigzag...@xxxxxxxxx wrote:
On Feb 5, 5:02 pm, Charles Hooper <hooperc2...@xxxxxxxxx> wrote:
On Feb 5, 4:45 pm, zigzag...@xxxxxxxxx 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.
.
- References:
- Permsssions to create sql profiles
- From: zigzagdna
- Re: Permsssions to create sql profiles
- From: Charles Hooper
- Re: Permsssions to create sql profiles
- From: zigzagdna
- Permsssions to create sql profiles
- Prev by Date: ORACLE / FINANCIALS DBA - 6/12 MONTH CONTRACT IN NY CITY
- Next by Date: Re: The Query From Hell
- Previous by thread: Re: Permsssions to create sql profiles
- Next by thread: Why Oracle is not adding a second to date/time:
- Index(es):
Relevant Pages
|
