Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Testing a table existence
I should have said however that Andrew's answer was much better than mine.
-- 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 ****************************************** "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:3c16249d$0$236$ed9e5944_at_reading.news.pipex.net...Received on Tue Dec 11 2001 - 09:36:24 CST
> "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
>
> ******************************************
> >