Database Security

Question

How to protect a SQL Server database from viewing others?

Answer 1

Maybe (I cannot be sure) what you are looking for is how to configure the server securely.

Here's a good resource that explains it all for SQL Server 2000, look for "SQL Server 2000 Security" in this page:

http://www.databasejournal.com/article.php/1503191

Answer 2

By setting up user accounts and passwords, assigning appropriate roles to them, and keeping them safe and secure :)

Check out CREATE LOGIN, DROP LOGIN (SQL Server 2005), sp_grantdbaccess, sp_revokedbaccess, sp_grantlogin, sp_droplogin, sp_addlogin, GRANT, DENY, REVOKE statements for more information.