Hi Guys
How can we ensure data security in sql server? If we have ms access frontend and sql server as a backend then there are chances that any access frontend can access to the data stored in sql server . Is there anything like locking tables / password protection or something similar that will prevent the frontends to access the backend if they don't have access to it? Only the Access frontend which has authoroization can access the backend.
Any help will be much appreciated.
Thanks
How can we ensure data security in sql server? If we have ms access frontend and sql server as a backend then there are chances that any access frontend can access to the data stored in sql server . Is there anything like locking tables / password protection or something similar that will prevent the frontends to access the backend if they don't have access to it? Only the Access frontend which has authoroization can access the backend.
Any help will be much appreciated.
Thanks