encrypt stored procedure

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Frank Kalis SSC Guru Points: 111183 More actions · Answer 1

Look at CREATE PROCEDURE in BOL

CREATE PROC [ EDURE ] [ owner. ] procedure_name [ ; number ]

[ { @parameter data_type }

[ VARYING ] [ = default ] [ OUTPUT ]

] [ ,...n ]

[ WITH

{ RECOMPILE | ENCRYPTION | RECOMPILE , ENCRYPTION } ]

[ FOR REPLICATION ]

AS sql_statement [ ...n ]

You might also want to search the web on how easy it is to decrypt them back again

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 2

Another thing you can review is the db_denydatawriter. This will allow access to the DB and they won't be able to change anything.

Good Hunting!

Chris Jones-133875 SSC Enthusiast Points: 141 More actions · Answer 3

Thanks, the encryption works, any suggestions on where to find the decryption

Frank Kalis SSC Guru Points: 111183 More actions · Answer 4

Hey, I won't tell you that directly. But a good start would be to google on those words.

--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]