On Tue 28 Mar 2006 09:13, vignesh wrote:
Hello all Can I have multiple authentication queries in sql.conf file. There are different ways by which we want to autheticate the users. I will let you know what I exactly want. I want to authenticate users based on the CLID and the remote ip address. The problem is that the remote address has to be searched from a set of ips. I will give you a example Suppose that we have a user 9204 and if the call for this particular user comes from a set of ips like 222.223.33.24 or 33.44.334.44( which will be present in some database tables) etc only then user will be authenticated.
This is very easy to do with a database stored procedure. Change your query to call a single sql function, then put all the different queries you need inside that function. Cheers -- Peter Nixon http://www.peternixon.net/ PGP Key: http://www.peternixon.net/public.asc