authid current_user and loops

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Mon, 12 May 2003 16:21:56 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703A994C3@lnewton.leeds.lfs.co.uk>

At the risk of stating the obvious then, sounds like something is broken with the database.
I tested it here and it works fine - all_tables shows me all the tables in another user when I query it looking for tables owned by that other user.

What version of Oracle ?

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: apurba.kalita_at_lycos.com (Apurba Kalita) [mailto:apurba.kalita_at_lycos.com]
Posted At: Monday, May 12, 2003 4:04 PM
Posted To: server
Conversation: authid current_user and loops Subject: Re: authid current_user and loops

Strange. It seems to pick up only the first one. I dropped table A and got table B as output. I tried removing the where condition and putting an if condition(if table_name in ('A','B','C')) and I got all the tables. Strange!!! Received on Mon May 12 2003 - 10:21:56 CDT