Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ukshir
Starting Member
2 Posts |
 Posted - 2010-05-21 : 06:37:01
|
| Hi,When I ship the SQL Server express database with my application anyone can see the schema ,tables,views, stored Procedures etc by accessing the SQL Server database instance using the Visual tool. How can I protect my SQL server database so that no user can see the schema ,tables,views,SP etc? |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-05-21 : 07:23:43
|
| You can encrypt the views and sp code using "with encryption" options..Make sure to take a backup of code because after encryption even you cannot see the code.regards,BohraI am here to learn from Masters and help new bees in learning. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2010-05-21 : 10:06:04
|
| Encryption is so easy to reverse it's almost a waste of time. If you install a SQL database on a client's computer and someone there has sysadmin access, there is nothing that you can do to prevent them from seeing views/tables etc. You can slow them down (like with encryption), but you cannot prevent it.If your procedures are so sensitive that clients cannot be allowed to see them, then you should host the SQL server and not give it to them.--Gail ShawSQL Server MVP |
|
|
|
ukshir
Starting Member
2 Posts |
Posted - 2010-05-22 : 14:30:03
|
| Thanks pk bohra and GilaMonser.... got the idea... Thanks again :-) |
|
|
|
|
|
|
Protecting SQL Server Schema (and MDF files)