Re: SET ROLE in PL/SQL

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?
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
--------------------------------