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 |
|
asifbhura
Posting Yak Master
165 Posts |
 Posted - 2010-04-05 : 07:04:44
|
| Hi,How can i secure my tables or views or SP, so no one can open it.like, we create .dll file for application,is there anything in SQL server to secure my database. Regards,ASIF |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-04-05 : 07:17:30
|
| By securing, do you mean hiding the code then you can use with encryption options while defining views and SP.Example:create view vEmp with encryption asselect empno, ename from empRegards,Bohra.I am here to learn from masters and help new bees in learning. |
 |
|
|
senthil_nagore
Master Smack Fu Yak Hacker
1007 Posts |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2010-04-06 : 08:38:48
|
| Hi,Ensure that you have script out all the code for later modification,if you ones use "with encryption" you can't view the code even sysadmin.Thanks,Gangadhar |
|
|
|
|
|
|
how can i secure tables or SP for.....