April 23, 2003 at 6:02 am
Is it possible to secure the information in my database so that a third party application cannot read the data from the tables? I am in a situation where the third party has full access to the SQL server because his application also uses it.
April 23, 2003 at 6:45 am
If the other app has sysadmin rights, no. Otherwise only users with a valid login AND permissions can access your data. If it is just a 'plain' user and not sysadmin, you could either remove the login from your db, or you could remove any permissions granted to the login (if it wouldnt break something else), or do explicit denies on your tables.
Andy
April 23, 2003 at 8:51 am
Agree wtih Andy. Can't do it if they are sysadmin. I doubt they need sysadmin access, most apps don't. I'd lean on them to use a regular user.
Steve Jones
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply