Posted by David Portas on 07/24/05 10:59
You can't deny a SYSADMIN from accessing your database. You just have to
ensure that only the right people have the SYSADMIN role.
To secure your database through your application, read about Application
Roles in Books Online. Make sure all access to data is through stored
procedures so that you don't have to grant permissions directly on tables.
--
David Portas
SQL Server MVP
--
Navigation:
[Reply to this message]
|