"Andrew Mobbs" <andrewm_at_chiark.greenend.org.uk> wrote in message
news:m9x*Svybp_at_news.chiark.greenend.org.uk...
> Niall Litchfield <n-litchfield_at_audit-commission.gov.uk> wrote:
> >However you need dba privs to query this view and would want to specify
the
> >owner of the table.
>
> To be pedantic, you need select_catalog_role privilege, not full DBA.
Quite right. to be really really pedantic one needs select privs on
USER$,TS$,SEG$,OBJ$ AND TAB$.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Tue Dec 11 2001 - 09:20:50 CST
