Encrypted objects exposed

Documents SQL Server 2005, 2008, 2012 and Azure databases.

Encrypted objects exposed

Postby dshort » Thu Feb 13, 2014 9:45 pm

the new version exposes the entire text of encrypted procs and functions. Prior versions would not do this. Is this an adjustable parameter on generation? This is a very bad exposure as we'd like to present the documentation to audiences that shouldn't have access to encrypted code.
Posts: 6
Joined: Thu Dec 30, 2010 4:36 pm

Postby Brian Donahue » Mon Feb 17, 2014 11:03 am


The odd thing is, SQL Doc should have been decrypting objects in all versions; it's a feature of SQL Doc.

You can try this: create a new user in the database and give it VIEW DEFINITION only. Then connect as that user from SQL Doc. Any encrypted procedures should just have the text "-- object has been encrypted".

It's sort-of mentioned here in the permissions doc for Red Gate SQL Tools.
http://documentation.red-gate.com/displ ... L+Compare#

Hope this helps!
Brian Donahue
Posts: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Doc 3

Who is online

Users browsing this forum: No registered users and 0 guests