Groups | Blog | Home
all groups > sql server (microsoft) > august 2003 >

sql server (microsoft) : hide stored procedure's source code


Oleg Ogurok
8/26/2003 11:19:53 AM
Hi all,

I was wondering if there was a way to prevent server admins from seeing the
source code of the stored procedures. Can the source code be precompiled and
then removed? Is there an obfuscator software?

Thanks.

-Oleg.

ChrisB
8/27/2003 6:35:48 AM
Check the WITH ENCRYPTION option when creating your stored procedure in
Books Online.

Chris Bassett
Precision Systems Consulting, LLC
www.precisys.com

"Oleg Ogurok" <oogurok@thecramgroup.ihatespammers.ireallydo.com> wrote in
message news:1dd79$3f4b7a6b$825ec943$11668@nf1.news-service.com...
[quoted text, click to view]

John Bell
8/27/2003 8:44:03 AM
Hi

If you encrypt your stored procedures then you should maintain a separate
copy that is not encrypted; preferably in a source code control system.

John

[quoted text, click to view]

AddThis Social Bookmark Button