August 6, 2003 at 7:36 pm
Hello everyone
Im probobly showing my absolute lack of knoweledge here but
What is possible to encrypt in SQL server
triggers ?
SP's ?
Views ?
im talking about the actual code that goes into them as opposed to the data they may create or display
any help or direction is much appreciated !
------------------------------
Life is far too important to be taken seriously
August 6, 2003 at 9:04 pm
quote:
What is possible to encrypt in SQL servertriggers ?
SP's ?
Views ?
yes,yes,yes.
Also, functions.
Note that the SQL2000 encryption (for t-sql code, not for login passwords) is fairly easily crackable. There's freeware on the web for decrypting objects, so the WITH ENCRYPTION option is ok for the casual prowler, but maybe not for the determined hacker.
Cheers,
- Mark
Cheers,
- Mark
August 6, 2003 at 9:17 pm
Thanks for that information
I think I could start with that first and then see how else to lock down the system
Thanks again for the info ! 🙂
Made my and hopefully my bosses day 8)
------------------------------
Life is far too important to be taken seriously
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply