Preventing users from deleting SQL data
- by me2011
We just purchased a program that requires the users to have an account in the MS SQL server, with read/write access to the program's database.
My concern is that since these users will now have write access to the database, they could directly connect to the SQL server outside of the program's client and then mess with the data directly in the tables.
Is there anyway I can prevent access to the database while still allowing access via the client program?