Insufficient privileges for SQL profile operation

Quote:

Originally Posted by ndisang

I tried to execute the sys package below to improve my query. I submitted as the creator of task TEST02. The error makes you think its simply a privilege issue..but as sys I grant
grant execute on sys.dbms_sqltune to XXXXXX. Still complains same thing.
SQL> execute sys.dbms_sqltune.accept_sql_profile(task_name => 'TEST02_TASK',replace => TRUE);
BEGIN sys.dbms_sqltune.accept_sql_profile(task_name => 'TEST02_TASK',replace => TRUE);
*
ERROR at line 1:
ORA-24265: Insufficient privileges for SQL profile operation
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_SQLTUNE", line 5659
ORA-06512: at "SYS.DBMS_SQLTUNE", line 5535
ORA-06512: at "SYS.DBMS_SQLTUNE", line 5564
ORA-06512: at line 1

ORA-24265: Insufficient privileges for SQL profile operation
Cause: A DDL operation was attempted on a SQL profile by a session without the proper privileges.
Action: Grant the user the appropriate privilege.

anyone seen this?
Thanks

Here is the response from Oracle.....

Please grant explicit privileges to the user you're trying to manipulate the profiles with, for th
ese privs.:
CREATE ANY SQL_PROFILE, DROP ANY SQL_PROFILE, ALTER ANY SQL_PROFILE .

I haven't done it...but I think that is what I needed.
thanks all