I need to add security to a database I have setup. I have lots of tables in my backend database that my front end database application links to. Is there someway I can set up security on the backend database so that only the front end application can link to the tables? I tried setting a password on the backend database, but that didn't work, because it locked out my front end application as well. Is there some way to set a password on the backend database, and somehow put code in the frontend application that will pass it the correct password so that only my front end application can access the tables?
Thanks!
Thanks!
