The SQL server architecture isn't (and neither other rdbms architecture is - except of maybe the embedded ones) made like this - because the authentication/authorization mechanism is more complex than that. I suggest you read trough this article:
http://msdn.microsoft.com/en-us/library/bb669078.aspx[
^]
[update]
First of all, if you make windows application, don't tag your question asp.net.
Second: if you want to hide database content completely, sql server is not the best approach. As I mentioned, administrator (local windows administrator also) is superuser in sql server. And using sql server might not be the best choice in such cases for other reasons too. Encrypted database is a feature from SQL Server Enterprise, and I am pretty sure you won't deploy this edition for a windows application. With SQL server express you have no real choices. With SQL CE you have. See:
http://msdn.microsoft.com/en-us/library/gg592949.aspx[
^], but be aware to keep the password safe - which is really hard if you have to install everything on the client computer.
You have other embedded database engines to choose from, which have built-in, or third party encryption, such as SQLite:
http://sqlcipher.net/[
^],
http://www.sqlite-crypt.com/?gclid=CLrd242v5bcCFVMQtAod23YAmQ[
^],
http://www.sqlite-encrypt.com/[
^]