Security in SQL Server 7

[markshiffer]

I am deploying a product using SQL Server 7 as the backend database. I need to figure out a way to allow the end user to administer their SQL Server install without being able to acess my table structure, as it is propritary. Any clue as to how I could do this?

 

[jnicho02]

I can't see any way of stopping them, they will have to be 'sa' to create the database and will therefore have full access rights.<br>
One of the benefits of SQL Server is that databases and stored procedures can be viewed and adapted.<br>
<br>
Try reverse engineering the SMS database and you'll see Microsoft's solution - make the database design confusing so that it takes three days to find out how it works.

 

[bporter]

HIding table structures is practically impossible, as you have to see the table to query it, and they will have the SA password to install the database. It is possible to encrypt stored procedures with the ENCRYPT option which should give you some protection if you keep the database "smarts" inside of SP's.