I know that VServer has a "master" table for users at server level, but I want to have several databases on my server, and I want to have different users (i.e. 10 from one organisation, and 5 from another company etc), but if I had listed users available on login in my front end (Xojo), then I would have got all 15. So how do you do it with different users for different databases.
I'm thinking of having the users stored in a table in the database itself, and only have a "masterUser" for each database on the login to the server, this is for getting the users, then the user has to use the login and password to contiue in the front end app.
I of course then have to find a way to enqrypt the password, or at least not store it in plain text.
Or have I totaly misunderstood something?