Re: authid current_user and loops

Norman Dunbar wrote:

> Hi Kamal,
>
> I've tested this on 9.2.0 and 9.2.0.3 and it works fine - as I would
> expect it to have done. I think you might have a broken database, unless
> anyone knows any other reason why this problem should be occurring - I
> can't think of a reason, nor have I come across this before.
>
> Cheers,
> Norm.
>
> -------------------------------------
> Norman Dunbar
> Database/Unix administrator
> Lynx Financial Systems Ltd.
> mailto:Norman.Dunbar_at_LFS.co.uk
> Tel: 0113 289 6265
> Fax: 0113 289 3146
> URL: http://www.Lynx-FS.com
> -------------------------------------
>
> -----Original Message-----
> From: kamal80_at_virgilio.it (Kamal) [mailto:kamal80_at_virgilio.it]
> Posted At: Monday, May 12, 2003 4:18 PM
> Posted To: server
> Conversation: authid current_user and loops
> Subject: Re: authid current_user and loops
>
> > can you see the three tables in ALL_TABLES when you simply login as
> user
> > Y and select owner,table_name from all_tables ?
>
> Sure.
>
> > PS. What version of Oracle ?
>
> 9iR2.
>
> Thank you.
>
> Kamal

Sounds like a good time to suggest the following:

1. Run DBV to check the physical integrity of the datafiles
2. Run a full export to check the logical integrity of the database
3. Run catalog.sql followed by catproc.sql

Try your query again.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)