Networks

Hi!

If you are selling an apllication that relies on MS SQL 7 as a database you cannot hide the database schemea or the table layouts or anything from the SQL 7 sa user.

It's just not possible to do it in that way.
however you can distribute your database on CD as a offline database or soemthing, I don't remember exactly what it was called, that way you would be allowed to distribute your database on CD and also lock everything from anyone and only allow access to a specifik user that you decide yourself, but this will make the database static and they won't be able to do updates or inserts.

If they are to be allowed to update and insert new records into your table they cannot be hidden from superuser.

That's the nature of superuser and admin accounts on all systems and that's why they are there.

/Hasse

If your code is complete and will not be changed, you can encrypt it with SQL 7. If this turns out to be impossible for you, such as updates and so on, then you could use a third party encryption program,like InstalShield, etc...
hbp

This question was auto closed due to inactivity