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 3 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply