Encrypted objects exposed

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

Moderator: JonathanWatts

Encrypted objects exposed

Postby dshort » Thu Feb 13, 2014 10: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.
dshort
 
Posts: 3
Joined: Thu Dec 30, 2010 5:36 pm

Postby Brian Donahue » Mon Feb 17, 2014 12:03 pm

Hello,

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: 6670
Joined: Mon Aug 23, 2004 10:48 am


Return to SQL Doc 3

Who is online

Users browsing this forum: No registered users and 0 guests