Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Testing a table existence

Re: Testing a table existence

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 11 Dec 2001 15:36:24 -0000
Message-ID: <3c162844$0$225$ed9e5944@reading.news.pipex.net>


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...

> "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:36:24 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US