How to hide the tables and table relations to end user.
Hello, I am writing a data-driven application using ADO.NET1.1 and MSDE2000. My question is:
After installing the MSDE and database files (*.mdb) on end user's machine, how to prevent end user from getting the table names, designs and relations by some tools, such as SQL Server enterprise Manager? (User will have administrator permissions to install, start and stop MSDE.) Is it possible to hide such information?
Thanks.
-Zhenyu2003
You might want to reconsider your strategy giving the "common" user administrator privileges. An administrator can virtually do anything to the system. Seeing some table names is likely turns out to be the problem to worry about the least in that respect.
Why do you want to hide these informations?
If you are concerned with legal questions, then you should have a contract anyway. If they violate this contract, by copying your intellectual property, then sue them.
--
Frank Kalis
Microsoft SQL Server MVP
http://www.insidesql.de
Ich unterstütze PASS Deutschland e.V. (http://www.sqlpass.de)
Basically you can not hide from the admim I suggest looking at the privs the user really needs and granting only those.
If you use SQL 2005 is much easier and data can in fact be hidden from admins, schema can not.
