This discussion is archived
2 Replies Latest reply: Oct 4, 2012 7:03 PM by rp0428 RSS

Autotrace

djbecker Newbie
Currently Being Moderated
I've been having problems with the Autotrace functionality. Whenever I push the autotrace button, I get a popup as follows:

Insufficient privileges
!AutotraceAction.6!

I granted myself the PLUSTRACE privilege, but it doesn't appear to have any effect (after logoff/logon)

Thanks in advance...
  • 1. Re: Autotrace
    Gary Graham Expert
    Currently Being Moderated
    Hi,

    Not sure if I can give a definitive answer. It probably depends on both the SQL Developer and Oracle DB versions in use. And based on the error message, I would guess your SQL Developer version is not current. Unless you require it to access an older DB version like 8i, my recommendation would be to upgrade.

    Assuming a 10g or 11g DB with any 2.x or 3.x release of SQL Developer, having SELECT_CATALOG_ROLE should be sufficient. For an older DB release, I would just be guessing, but the 9i DB doc for Autotrace in SQL*Plus is here:
    http://docs.oracle.com/cd/B10501_01/server.920/a96533/autotrac.htm

    Regards,
    Gary
    SQL Developer Team
  • 2. Re: Autotrace
    rp0428 Guru
    Currently Being Moderated
    Welcome to the forum!

    Whenever you post provide your full sql developer version and the platform and version you are using.

    Version information is typically needed to provide specific help.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points