Re: Using Autotrace

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 4 Jul 2002 02:10:46 -0700
Message-ID: <a20d28ee.0207040110.c5925dc@posting.google.com>

"Kevin Carlson" <kcarlson_at_speakeasy.org> wrote in message news:<ui7cqahmga095c_at_corp.supernews.com>...
> Pardon the newbie question, but I'm having trouble granting myself
> permission to run Autotrace as a non-sysdba user (Oracle 8i Enterprise
> downloaded from OTN running on Win2K). I can login with "connect
> sys/manager as sysdba" to execute "Set autotrace on", but how do I grant
> permission to an "ordinary" dba account? I've already granted
> SELECT_CATALOG_ROLE to access the V$ tables, but still get error messages
> about not finding PLAN_TABLE. What is there left to do?
>
> Thanks much,
> Kevin

grant select, insert, delete on <owner>.plan_table to public create public synonym plan_table for <owner>.plan_table

running the plustrce.sql script from $ORACLE_HOME/sqlplus/admin

This is documented of course.

Regards

Sybrand Bakker
Senior Oracle DBA Received on Thu Jul 04 2002 - 04:10:46 CDT