Re: Security violation by my host
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Thu, 19 Apr 2007 22:20:04 +0000 (UTC)
Mike (no@xxxxxxxxx) writes:
Cannot answer your question directly as you need legal advice however in
the mean time I would sugest adding encryption to you stored procedure
as follows:
CREATE PROCEDURE MyProcedure @Pramr1 int, @AnotherParam nvarchar(10), ....
WITH ENCRYPTION
AS
.SQL code
GO
This will encrypt the SP in the database so if anyone opens it will be
unreadable. A word of warning make sure you have the SP code some where
safe.
Note that this is not real encryption, only obfustication. Anyone who
wants to get the code in clear text, and who knows how to do a Google
search will do so.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: Security violation by my host
- From: Mike
- Re: Security violation by my host
- References:
- Security violation by my host
- From: Jenny
- Re: Security violation by my host
- From: Mike
- Security violation by my host
- Prev by Date: Re: application roles and strong passwords
- Next by Date: Re: application roles and strong passwords
- Previous by thread: Re: Security violation by my host
- Next by thread: Re: Security violation by my host
- Index(es):
Relevant Pages
|
