>Hi Sergey
>Thanks for replying
>
>I'm asking help here...
>That what i'm doing now ....encryping data...but that will
>slow down speed in my software....and anyone can see the SP or UDF.
>Seem to me SQL SERVER also not very good in security measures, should M$ ....
>
>
SP's can be both be encrypted when created. Check out CREATE PROCEDURE and CREATE FUNCTION in the BOL.
SQL Server is very good at security, as far as protecting the data from users. But there must be a level of trust between the developer and the client's DBA. You can't always be on site to fix their problems. And, as you pointed out, encrypting the data will cost performance. There is a trade off.
Just my opinion.
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
