Post reply

How to encrypt all the stored procedures in a database in stead of encryption one by one?

  • April 18, 2006 at 11:45 am

    #111750

    I want to encryption all my stored procedures in the database, but if i do it one by one, it's really a pain, so anyone has a better idea?

     

    Thanks

  • April 21, 2006 at 8:00 am

    This was removed by the editor as SPAM

  • April 21, 2006 at 8:52 am

    #633533

    to be honest there's little point as anyone can download a proc to decrypt them. .. but -- script them all out and do a find and replace on the as to with encryption as

    If you want to protect the procs a far better way is to restrict the permissions on syscomments - that way the procs can't be viewed.

    [font="Comic Sans MS"]The GrumpyOldDBA[/font]
    www.grumpyolddba.co.uk
    http://sqlblogcasts.com/blogs/grumpyolddba/

Viewing 3 posts - 1 through 2 (of 2 total)

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