I checked out sqlops module, this will solve the problem

only when I get the authentication password (secret)

of the user inside request route. For this I tried checking 

kamailio pseudovars but haven't found one. Therefore, I am 

sticking with auth_db module.If this is possible by any other way

do let me know.

thanks,

Arish