Frequently Asked Questions

Database login for multiple clients

Question:

Since the middle tier is doing the database access on behalf of 
multiple thin clients, do we lose the ability to associate a 
particular database user ID with a particular human user?  This 
would seem to be a problem if you want to grant different access 
rights to different groups of users at the database level.

Answer:

Yes, if you want to use one connection to the database for all 
clients.  If you want, you can have the clients login to the 
database.  To do this, create an automation method on the 
RemoteDataModule that takes the user name and password and use 
that to login to the database.  Also, drop a TSession on your 
RemoteDataModule and set it's AutoSessionName property to True.