I am distributing SQL Server 7.0 with one of my product. It is an SQL Server database application.
Is there any way to hide the database schema from the members of superusers group, so that my product details will not visible to others. Also it is a major security issue as far as my product is concerned.
This conversation is currently closed to new comments.
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.
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
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
SQL Server 7.0
Is there any way to hide the database schema from the members of superusers group, so that my product details will not visible to others. Also it is a major security issue as far as my product is concerned.