Re: Privilege of 'internal' user

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 - 07:35:38 CST