Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Problem with date query - simple?
On Sat, 08 Feb 2003 22:32:55 -0800, DA Morgan <damorgan_at_exesolutions.com> wrote:
>
>Presumably you are using an after logon trigger. Why all the convoluted SQL? All of
>this information is readily available to the trigger using SYS_CONTEXT.
>
>Daniel Morgan
Each of the databases use a logon trigger to populate a local table and I query these remote tables to populate a central database. Due to the nature of some of the third party and in-house applications being used to connect to the different databases / schemas, getting the appropriate required information isn't always straight forward (actual userid's may not get stored in session_user, current_user, etc.).
Much of this environment I inherited and haven't had a chance to thoroughly review. I am hoping to change several key things, but currently am just trying to make management happy.
Regards,
Don. Received on Sun Feb 09 2003 - 13:02:32 CST