April 4, 2008 at 4:42 am
I have several views in a database and I would like to encrypt them all. Is there any stored procedure that can be used to encrypt all views instead of scripting every view and encrypting it separately?
April 4, 2008 at 4:51 am
Unfortunately you're going to have to alter each view's definition and encrypt them that way. Or you could use a third-party application - I'm sure there are some out there that do this for you.
April 4, 2008 at 5:26 am
Just bear in mind that the 'encryption' of views/stored procs is not unbreakable.
Took me under 5 min last time.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply