General discussion

Locked

SQL Server 7.0

By RamanathanS ·
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.

5 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

SQL Server 7.0

by Hasse MCSE/Brainbench In reply to SQL Server 7.0

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

Collapse -

SQL Server 7.0

by RamanathanS In reply to SQL Server 7.0

The question was auto-closed by TechRepublic

Collapse -

SQL Server 7.0

by headbangerphil In reply to SQL Server 7.0

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

Collapse -

SQL Server 7.0

by RamanathanS In reply to SQL Server 7.0

The question was auto-closed by TechRepublic

Collapse -

SQL Server 7.0

by RamanathanS In reply to SQL Server 7.0

This question was auto closed due to inactivity

Back to Networks Forum
5 total posts (Page 1 of 1)  

Related Discussions

Related Forums