Re: Minimum privileges to run utlbstat and utlestat

I've never done this as some user other than one who has DBA privileges. But you can fix this easily by granting the SELECT ANY TABLE privilege to the user. Or you can manually grant the privileges to the ts$ and file$ tables.

HTH,
Brian

xo55ox_at_hotmail.com wrote:
>
> Hi,
>
> What are the minimum privileges required for a user to run the
> utlbstat.sql and utlestat.sql if I don't want the scripts to be run
> under sys or system user?
>
> Currently, I have a user X who has CONNECT, RESOURCE and
> SELECT_CATALOG_ROLE privileges. But once the SQL statement tries to
> select from v$filestat, ts$, v$datafile and file$ all together to create
> a view, it fails with ora-01031 insufficient privileges. I did try to
> grant select object privilege on ts$ and file$ to the user. And I am
> able to select v$filestat and v$datafile manually. Am I still missing
> some privileges? How can I fix it?
>
> Any information/help will be highly appreciated.
>
> Thanks in advance.
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================