Web API authenticate combination of username and password in appain

If you are creating a process that validates the username and password, pass the username and password as the parameters. Get the username and password using the username from Appian table. Check the passed values with retrieved values.

Have you made success with the suggested solution of accessing apian table??
Having similar requirement

No. I never did. They will be in primary storage in encrypted format. I thought they will have user table with username and password.

Thank you for your answer
I already think at this Method but the problem is i have different environment stages ( Dev , Test , Deploy Env.) so i want a OOTB solution that will work with all different Environments (which may have different installation Configurations ) without a manual interference
Thanks