Re: Advice : Security on Oracle - set role at application
From: MMason <mmason_at_c-s-p.com>
Date: 1995/06/24
Message-ID: <3sguka$9r4_at_clarknet.clark.net>#1/1
Date: 1995/06/24
Message-ID: <3sguka$9r4_at_clarknet.clark.net>#1/1
In article <yyyyy.3.003B9959_at_hk.linkage.net>, yyyyy_at_hk.linkage.net says...
>
>The idea is great, but how can I 'set role' through application?
>Yours comment is appreciate!
>
>
You have to use dbms_session package. e.g.
dmbs_session.set_role ( 'rolenamewithupdateprivs identified by password' ); Received on Sat Jun 24 1995 - 00:00:00 CEST