Security Basics mailing list archives

SQL stored procedures encryption strength


From: Bénoni MARTIN <Benoni.MARTIN () libertis ga>
Date: Thu, 11 Nov 2004 20:03:46 +0100

Hi list !

I was wondering how secure is the encryption used for stored procedures in SQL Server 2000. I mean, when I create a 
procedure like this:

        create procedure dbo.aed_hd_ok_check
                @input char(64)
                ...
        with encryption
        as
        Begin
                ...
        end

the procedure becomes then encrypted, and even the sa account cannot see the source after that.

But no way to find in SQL docs which algorithm is used, and if there are ways to breack it down ...

Anybody knows about this ?

Thanks !




Current thread: