SQL Server - Protecting the Database Structure

[PraveenMenon]

Hello all in,

Is it possible to protect the database structure in SQL Server? when we pack and deploy the application, is it possible to restrict the user from accessing the tables,views, stored procedures etc. and modifying/copying the structure? By user, i mean all.. including the db administrator.

Thanks in advance..

 

[miq]

I would be surprised if i listen yes from anyone

 

[toetag]

personally i don't know of anyway of locking down. However, the easiest one (depending on what you are doing) is licensing. If you are creating a specific application for a client that would use an SQL server. put it in the licensing, any manipulation, modification...blah blah negates the contract and support.

Not sure it helps, but it wouldn't be the first time i've seen that type of licensing.

 

[PraveenMenon]

Miq, I guess it's time for you to get surprised... am sure there is a way to do this.
Toetag, you know it won't help a bit... may be we should work a little harder to figure out a way...
Also, if it is going to throw any light, there is a database encryption stuff... can we encrypt the whole db? Or is it possible to deeploy SQL server with it's data storing capacity alone? sans the Eenterprise Manager?
hmm.. lets try...
Thanks for the response Miq and Toetag. It surely did help.