Re: Password security

[Mike.Barton@xxxxxxxxxxxxxxxxx]

>>Hello,
>>
>>I am working on a tool development. The tool can be run by certain users
>>defined in my database. I do not want to give access to this database to any
>>user except the program using that database. The user should not see the
>>password by running the query. How can I maintain this security?
>>
>>Deepak Deshpande
>
>Deepak
>    you could change the access program to adopt authority
>but this will not work if a user has *ALLOBJ authority.
>Possibly the best route would be to encrypt the data and than have the
>program de-encrpyt it.
>
>HTH.
>
>Mike

But Bobs suggestion re validation lists is better !

(i temporarily mislaid my memory on them)

Mike




This communication and the information it contains: - (a) Is intended for the 
person(s) or organisation(s) named above and for no other person(s) or 
organisation(s). Access to this mail by anyone else is unauthorised. (b) Is 
confidential, and may be legally privileged or otherwise protected in law. 
Unauthorised use, circulation, copying or disclosure of any part of this 
communication may be unlawful. (c) May be susceptible to interference, and 
should not be assumed that it has come in its original form and/or from the 
stated sender or PinkRoccade UK accepts no responsibility for information, 
errors or omissions in this e-mail or use or misuse thereof or any act done or 
omitted to be done in connection with this communication. If you are not the 
intended recipient, please inform postmaster@pinkroccade.co.uk immediately and 
delete it and all copies from your system.