<!--- Bug 6842: Users assigned as bloggers on a blog app and given blog admin rights over a specific blog sometimes cannot download blog post attachments --->
<cfquery datasource="#application.config.DSN#">
	UPDATE		UserPermissions
	SET			ViewOK = 'yes'
	WHERE		AddOK = 'yes'
				AND CategoryID = 0
				AND MenuID IN (
					SELECT		AppID
					FROM		Application
					WHERE		AppTypeID = 30
				)
</cfquery>