Post reply

Encrypt Triggers

  • August 6, 2003 at 7:36 pm

    #83030

    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

    #468920

    quote:

    What is possible to encrypt in SQL server

    triggers ?

    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

    #468922

    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