Re: encrypting stored procedures

From: Jasper Smith (jasper_smith9_at_hotmail.com)
Date: 08/27/03 

Date: Wed, 27 Aug 2003 07:57:02 +0100

And do be aware that this is just obsfucation and not encryption and will
not prevent a determined customer viewing and/or modifying them. 

-- 
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Richard Douglass" <RichardD@arisinc.com> wrote in message
news:%23KoVhCDbDHA.2620@TK2MSFTNGP09.phx.gbl...
I was just informed that I must encrpyt the stored procedures for our
production database to prevent our customers from viewing and/or modifying
them.  The WITH ENCRYPTION option works well but we hav 4000+ existing
procedures.
Any ideas on the easiest (yet secure) way I can lock down the code?
Thanks!
Richard

Relevant Pages

  • Re: SQL or Access DB
    ... As far as encryption goes though... ... with Sql Server you can use SQL DMO and encrypt your stored procedures ... installation - Security was absolutely critical and in most instances, ... > then we create a nice gui around this database and sell it to automotive ...
    (microsoft.public.dotnet.languages.vb)
  • Re: newbie problem: updating an access db
    ... modifying the code to use SQL Server it still exhibited the same ... changed the path to the supplied access .mdb file in the web.config ... the delete and update commands, so now they just test whether Adnum= ?. ... get this code to work, I don't want to start modifying it to use MSSQL, ...
    (microsoft.public.dotnet.framework.aspnet)
  • RE: Views
    ... you must understand that SQL Server 2000 does not support ... database data encryption as such. ... following method in the KB below to enhance the security. ... Microsoft is providing this information as a convenience to you. ...
    (microsoft.public.sqlserver.programming)
  • Re: Protecting database from administrators
    ... >> there is no encryption while at rest it must still be secure. ... >> All the security MS has offered is weak. ... If it is attached to SQL Server ...
    (microsoft.public.sqlserver.security)
  • Re: MSDE Security (aka users looking at my apps database)
    ... > I have been called in more than once to untangle all sorts of developer ... let's think about a genious tool, RAC by SQL Server MVP Thanh Ngo.. ... even if SQL Server encryption has been defeated... ... think to privacy protection for sensible data... ...
    (microsoft.public.sqlserver.msde)