March 10, 2006 at 2:14 am
Hi,
If I need to encrypt existing SP in my database,
is there any know command or function to do it
all at once in script. I don't want to apply
all my old SP with 'with encryption' command
to my remote office.
I know that to encrypt a SP, we need to append this
command 'alter procedure xxxx with encryption'
and might have to use sp_helptext to get all
existing code.
Anyone have done it or know of any tool that can do it, pls
advise/thank.
Thank you.
March 10, 2006 at 9:42 am
Vladimir - not sure what your objection is towards doing this the conventional way...(with alter procedure...etc.)..
The only other way that I can think of is to directly modify the "encrypted" column in syscomments but BOL specifically warns against this...maybe you can use a test proc and see what happens...
**ASCII stupid question, get a stupid ANSI !!!**
March 12, 2006 at 11:17 pm
Hi,
Sorry if my objective is not clear. I am not a native English speaker.
Back to my question. I already have some DB with their views and SP not encrypted now.
I am told to look into encrypting all of them to prevent user from looking at them or
modify them.
I am thinking whether we can modify all the existing SP into encrypted one without
having to send my original SP with 'with encryption' command to my user again.
Thank you
March 23, 2006 at 2:04 pm
just as an fyi - have you gone through all the articles on this site that talk about encryption ?! In case you haven't - here's one on worst practice - encryption - you'll also find other posts if you search the "discussions" that may help you...
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply