My point is that a non-privileged user can issue the query you list. I'm
sure that connecting as sysdba works but you should not need to grant this
privilege to anyone other than sys really.
--
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
******************************************
"Christophe" <christophe.cavelier_at_template-software.fr> wrote in message
news:jcLO7.45$G02.47662_at_monolith.news.easynet.net...
> Hi,
>
> I found the problem with your indication.
> The user need 'sysdba' privilege. It wasn't necesary with Oracle 8.0.5 !
> It's strange but it's works.
>
> Thanks very much for your help.
> Christophe
>
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> a écrit dans le
> message news: 3c0b70fd$0$8508$ed9e5944_at_reading.news.pipex.net...
> > "Christophe" <christophe.cavelier_at_template-software.fr> wrote in message
> > news:qlJO7.15$G02.20392_at_monolith.news.easynet.net...
> > > Hi,
> > >
> > > I'm a beginer with Oracle and i have the following problem.
> > >
> > > I use a development tool which make a request for retrieving all
> available
> > > oracle table.
> > > Oracle don't accept this request (Error ORA-01039) when i use 'system'
> > user
> > > for example (dba user) but accept only with 'internal' user.
> > > I have this problem with Oracle 8.1.7 only (with Oracle 8.0.5, it work
> !).
> > > The request is :
> > > SELECT DISTINCT TABLE_NAME FROM ALL_CATALOG WHERE OWNER=USER OR (
> > > OWNER='PUBLIC' AND TABLE_NAME NOT IN ( SELECT SYNONYM_NAME FROM
> > ALL_SYNONYMS
> > > WHERE TABLE_OWNER = 'SYS' OR TABLE_OWNER = 'SYSTEM'))
> >
> > This works fine under 8.1.7 for me. Internal is of course connecting as
> > sysdba. Is the database in a special state? not up or startup restricted
> or
> > some such?
> >
> >
> > --
> > 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 Mon Dec 03 2001 - 08:20:36 CST
