<sarcasm on>
Guys, just give everyone DBA privs and then you never have a privs problem.
:-)
<sarcasm off>
Jim
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3c16249d$0$236$ed9e5944_at_reading.news.pipex.net...
> "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 - 10:20:01 CST