I am creating a little SQL utility that is going to run a quick query to update a field in a SQL database table if there is a date in it.

In our organization I found that there are two different passwords on our systems out in the field.

What my question is, how can I program the two passwords into my utility so that when it runs if it is not the first password, it will check the second one then run my update query.

If anyone can help with this I sure would appreciate it.

Thanks
Garry B

NEOLLE

10-26-2004, 05:29 PM

Hi Garry,
Ideally you can create a users profile table where both user passwords are in. You can create a function in VB or in PLSQL to verify if this passwords exits. Use this function whenever you do DML Commands. :)