One way to give roles within an application but not have them available
otherwise is to create the role with an assigned password. -- CREATE ROLE
rolex IDENTIFIED BY passx
Grant the role to your user or another role but do not make it a default
role. In your application, enable the role for the user specifying the
password. There is somewhat of a security risk as the password for the role
is hard-coded into the application.
--
Thomas W. Vanya
Oracle and OracleRdb Database Administrator
Eastman Chemical Company
-------------------------------------------------------------------------
(Due to proliferation of spammers, remove nospam from address.)
Douglas Scott <Douglas.S.Scott_at_boeing.com> wrote in article
<34390FB0.88133F77_at_boeing.com>...
> Can anyone point me to a third party product or information on using
> Oracle roles within an application? What I would like to do which I
> heard is possible is to set up roles with database privileges so that
> when a user runs a particular application they will have all the
> necessary table privileges needed by the application and when they exit
> the application all the privileges go away.
> --
>
> Douglas Scott
> Douglas.S.Scott_at_boeing.com
>
>
>
Received on Mon Oct 06 1997 - 00:00:00 CDT
