Re: authid current_user and loops

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Fri, 16 May 2003 14:57:42 +0200
Message-ID: <3EC4E046.9080409@science-computing.de>

Kamal wrote:
> However the problem doesn't seem to interest anyone... :(
>
> Do you think it can be considered a bug or something like that?
> It's quite uncomfortable to order by every query... and it could be
> bad to performance on big query when it's not useful...
>
> Regards,
> Kamal

I've got good and bad news for you:

After the initial setup that was (as far as I could tell) similar to your situation, I could reproduce that behaviour. Well table_names and users are different...

Playing around a bit with privileges (e.g. granting execute on test to public) and adding a debug package to the whole process, user Y would see all tables he got select privileges on.

Having reverted the setup back to the original state (I didn't drop everything, just recompiled the package, revoked and regranted execute on test to user Y and such, still everything worked as expected.

Unfortunately, I can't further investigate this at the moment, and I didn't noted my steps in detail. At least it seems to be possible to achieve what you expect.

Database is 9.2.0.1,
OS: Windows 2000

Cheers,

Holger Received on Fri May 16 2003 - 07:57:42 CDT