Hiding table structure from administrator

Hiding table structure from administrator

Post by Alanka » Sat, 22 Jun 2002 07:00:18



Hi,
I want to install a client server system at customer's
place. Even database will be created on customer's DB
server i.e. SQL Server. I don't want to reveal the table
structure of my system to the customer who will be admin
for DB as well.
Can that be done? If yes, please let me know how.

Regards,
Alankar

 
 
 

Hiding table structure from administrator

Post by Mike Wad » Sat, 22 Jun 2002 11:57:18


No it cant.

members of sysadmin are gods.. they can see everything and
do everything.   If you want to protect you application
you can encrypt you SPs but thats about it.   Or you could
I guess install a 2nd instance of SQL server on their
machine where they are not sysadmins.  

Quote:>-----Original Message-----
>Hi,
>I want to install a client server system at customer's
>place. Even database will be created on customer's DB
>server i.e. SQL Server. I don't want to reveal the table
>structure of my system to the customer who will be admin
>for DB as well.
>Can that be done? If yes, please let me know how.

>Regards,
>Alankar

>.


 
 
 

1. Hiding tables and data structure

We have developed a system with MS SQL Server 7.0 as database. When we
install this for a customer, we can hide the triggers and stored
procedures by encrypting them. This is not possible to do with the
tables. In MS SQL Server they can not be encrypted. How then can we
hide the tables and data structure as well for our customers. Are there
any suggestions when it comes to hiding the tables? Grateful for any
help!

Regards,
Stian!

Sent via Deja.com http://www.deja.com/
Before you buy.

2. Chairman Letter

3. Hiding Data Structures

4. For ASP Gurus [ Images and Database ] ( please help me ! )

5. bulk copy hidden structure CS_BLK_ROW???

6. MEMO fields and Dbase

7. Can I hide the structure of a database?

8. Access 2.0 patch

9. Q:how to hide my data for administrator or root (linux)

10. Hide System Tables/Expose User Tables

11. How to Create table using Old Table Structure

12. Copying the structure of a table into a temporary table without constraint and identities

13. Creating table having structure same as that of existing table