Minimum privileges to run utlbstat and utlestat

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. Received on Tue Nov 28 2000 - 17:16:38 CST