DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Insufficient privileges for SQL profile operation

  1. #1
    Join Date
    Sep 2001
    Posts
    200

    Insufficient privileges for SQL profile operation

    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
    Life is what is happening today while you were planning tomorrow.

  2. #2
    Join Date
    Sep 2001
    Posts
    200
    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
    Life is what is happening today while you were planning tomorrow.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width