Post reply

Hide SQL Script in SP

  • May 22, 2008 at 3:01 am

    #70070

    Hi

    I have developed SQL script which is run through an SP. Developers only need to pass parameters to the SP to provide designated data sets. If accessed, the script can be re-engineered to access data which needs to be maintained as secure. Is there any way in which I can hide the script in the SP, while allowing parameters to be passed and the SP to be executed?

    I hope you can help.

    Paul

  • May 22, 2008 at 3:22 am

    #819025

    Paul,

    Try this

    create procedure dbo.myTestProc with encryption

    ....

    That should encrypt the actual contents of the stored proc so the sql behind it cant be viewed. Obviously make sure this is only run in your live enviroment!

    Matt

  • May 22, 2008 at 3:28 am

    #819027

    Matt

    That's fantastic!

    Many thanks

    Paul

  • May 22, 2008 at 7:14 am

    #819109

    Please remember that this encryption is quite simplistic and is not bullet proof. There are tools to crack this encryption.

    I wish Microsoft built the encryption a much better way.

    ---------------------------------------------
    [font="Verdana"]Nothing is impossible.
    It is just a matter of time and money.[/font]

  • May 22, 2008 at 8:40 am

    #819166

    Thanks, Jacek0

    Gratefully noted.

    Paul

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply