Securing Table Data

[faccorp]

How would I deny Select statements on all my tables for all users? I can use DENY SELECT 'tablename' but it only applies to non-administrators. For security reasons, I only want a user to be able to access the data via the front end application.

I am using Windows authentication.

Essentially, I don't want to expose any of the raw data or structures of the database. I have encrypted all the stored procedures. Allowing access to Views is ok since this is what the front end app uses to view the data.

Thanks!

 

[mrdenny]

There is no way to prevent a user who has db_owner rights or sysadmin rights to the database from viewing the data within the table.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com