SysAdminn can also use the profiler to see the statements. That should
be possible. I haven't tested this, but thought it should be possible.

John

-----Original Message-----
From: Bianca Levy [mailto:[Email Address Removed]
Sent: Monday, October 20, 2003 10:27 AM
To: LazyDBA.com Discussion
Subject: Re: Encryption of Stored Procedure

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] 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] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page