You are here: Re: security of mssql database? « MsSQL Server « IT news, forums, messages
Re: security of mssql database?

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]


Удаленная работа для программистов  •  Как заработать на Google AdSense  •  England, UK  •  статьи на английском  •  PHP MySQL CMS Apache Oscommerce  •  Online Business Knowledge Base  •  DVD MP3 AVI MP4 players codecs conversion help
Home  •  Search  •  Site Map  •  Set as Homepage  •  Add to Favourites

Copyright © 2005-2006 Powered by Custom PHP Programming

Сайт изготовлен в Студии Валентина Петручека
изготовление и поддержка веб-сайтов, разработка программного обеспечения, поисковая оптимизация