authid current_user and loops

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 12 May 2003 17:34:31 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703A9C64B@lnewton.leeds.lfs.co.uk>

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 Received on Mon May 12 2003 - 11:34:31 CDT