How do I encypt the Code

happygv · May 18th, 2009, 07:39 AM

Hi,

I was thinking a lot on (may be call it "ENCRYPT") having the SQL code in Procedures/Triggers/Views not readable to "others". May be I dont get the right term other than encrypt while composing this.

I know I can restrict others from EDITing the SQL code in the database. Still I was thinking is there really a way to restrict people (who aren't supposed to) from viewing the code of SQL objects, such that the object are all executables and not for one to read the code. Like applications have executables/binaries.

Is there a way to do that? If so please put me to some pointers on this.

Thanks,

joefawcett · May 18th, 2009, 09:33 AM

Something like this: http://blog.sqlauthority.com/2007/07...ned-functions/

Although once encrypted no-one can see the source, it's not configurable to target just some roles.