You can create the stored procedure using the WITH ENCRYPTION option which
encrypts the stored procedure's entry in syscomments. But, if the user has
the appropriate access rights (system administrator, dbo, or create
procedures) he will be able to overwrite the stored procedure.
----- Original Message -----
From: <Jitendra.[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Monday, October 20, 2003 10:39 AM
Subject: Encryption of Stored Procedure


>
> Hi !
>
> Is there any way to encrypt the store procedure or prevent client from
> viewing or changing the store procedure. I am using MS SQL 7.0.
>
>
>
> Regards,
>
>
>
>
> Jitendra Pratap Hadap
>
>
>
>
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> Get today's cartoon: http://www.LazyDBA.com
> To unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page