Re: SET ROLE in PL/SQL
From: Armando Marcotulli <a.marcotNSP_at_srd.it>
Date: 1997/12/17
Message-ID: <3497B05A.D989A8DB_at_srd.it>#1/1
Date: 1997/12/17
Message-ID: <3497B05A.D989A8DB_at_srd.it>#1/1
Stefan Knopp wrote:
> We use dbms_session.set_role in a Developer2000 application with an
> Oracle 7.3.3 Server. The roles we programmatically set are non-default
>
> roles (excluded via alter user ... default role). It works quite well.
>
> Users have access to sensitive Objects only via the application - and
> not via sqlplus.
>
> S.Knopp /CSC Ploenzke Consulting, Germany
What does it mean?
[Quoted] Users connect to Oracle and then execute the dbms_session.set_role.
Do you use this method?
-- -------------------------------- Rimuovere NSP dall'indirizzo Remove NSP from email --------------------------------Received on Wed Dec 17 1997 - 00:00:00 CET