Re: Question on Oracle 8i

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: 2000/06/30
Message-ID: <962351015.2040.0.nnrp-02.9e984b29@news.demon.co.uk>#1/1

It pushes data into the dynamic
performance view v$session.

The rest of the code presumably
does a subsequent check against
this view.

This type of approach has been
built up into the sys_context()
functionality in 8.1 which allows
the Oracle equivalent of 'environment
variables' to be set through a CONTEXT
and calls to the packaged procedure
dbms_session.set_context();

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

Luis Aucañir wrote in message <395a106c_at_dnewserver.firstcom.cl>...


>Hi dudes,

>

>I have an question on Oracle. In Oracle Finantials we can make an

>restriction ussing the package DBMS_APPLICATION_INFO to permit that an user

>can see the records on tables. If we execute the line:

>

>DBMS_APPLICATION_INFO.Set_Client_Info(vOperUnit),

>

>where vOperUnit is the id from any user, then the user identified by

>vOperUnit can see the records on tables ... the question is ...  How works

>the package  DBMS_APPLICATION_INFO?.

>

>Thank's by your help,

>

>LA.

>laucanir_at_hotmail.com

>

>

Received on Fri Jun 30 2000 - 00:00:00 CDT