Re: SET ROLE command and FORMS

ap wrote:
>
> Hi
>
> I need help in the following :
> I have to use set role command in my application develop by Forms. I'd like
> to include password in this command. How to encrypt it ? Without encryption
> user can see source of application where password is set and then have no
> problem to enable role from e.g SQL*PLUS. How to avoid this situation ?
> Thanks for reply

Typically you would not give out the source (and thus reveal the password)...

Another option may be to have a database logon trigger (8i+) and have some sort of algorithm to deduce the password from the role you are trying to enable...

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk
(faster/mirrored at http://www.oradba.freeserve.co.uk)

Its not the voices in my head that bother me... 
  its the voices in yours.