Re: Session variables and PL/SQL

Read up on SYSTEM LEVEL TRIGGERS. Looks good. Thanks.

Ted

On Sat, 19 Jul 2003 14:09:26 -0700, Daniel Morgan <damorgan_at_exxesolutions.com> wrote:

>Ted Knijff wrote:
>
>> Hi,
>>
>> how can I best save and retrieve variables based on a session ?
>>
>> The problem :
>> -a user logs in multiple times from different clients / from the same
>> client PC (i.e. multiple sessions, same user)
>> - I want to save the session parameters (login time etc. - as in
>> v$session view) and access these variables from PL/SQL
>> - do I have to save his data in a table and retrieve them every time ?
>> - how can I best access the session-id to uniquely identify the
>> session (performance) ?
>>
>> TIA
>>
>> Ted Knijff
>> EMail: knijff_at_bigfoot.com
>
>Personally I'd alter the default profile and make it impossible to do so.
>
>But if you can't or choose not to ... look at SYSTEM TRIGGERS.
>--
>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)
>
>

knijff_at_x.bigfoot.com (remove x.) Received on Mon Jul 21 2003 - 03:04:34 CDT