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 |
|
o_sam
Starting Member
2 Posts |
 Posted - 2004-01-26 : 21:41:14
|
| Hi ,Is there any way that i could hide table, views, stored procedures in sql server 2000. This will be benefical when i give the application to Clients, so they dont have any chance to see the tables,views, SPs...ThanksSam |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2004-01-26 : 23:51:24
|
| Well, you could encrypt the stored procs, but I don't think that's generalyl reccomened for two reasons:1. If you don't keep backup copies ( scripts / database full of unencrypted versions), you can lock youself out of all your stored procs2. From what I understand, they can be decypted, but not super easily. Encryption just slows people down. It does not keep them out.What goal do you have in mind by keeping your clients out of the database? Maybe we can address that goal.Michael<Yoda>Use the Search page you must. Find the answer you will.</Yoda> |
 |
|
|
|
|
|
hide table, view, stored procedures in sql server