After the immediate reply from the foxweb team (thanks a lot) I have tried to simply connect to my sql server (in my case Mysql) and created a cursor in order to get the user table and it works perfectly :
SQLEXEC(mysql,"select name,password from usertable","users")
Auth.AuthTable = "users"
Auth.SaveCookie = 1
Simple as that !