Hi together,

can anybody explain what exactly the "approve" Checkbox in the folder attributes / permissions page does?
I want to completely disable the approval function - is this possible?

Best wishes
Sascha

Hi Sascha,

If you do not select any role/user to APPROVE then there is no approval mechanism. The approve checkbox shows up because you (the user) has approval rights on this item or the folder so the approval is active. The checkbox allows you to immediately approve this item while you're still editing it.

To remove ALL approval run the following under Host > SQL:

DELETE FROM {databaseOwner}{objectQualifier}DMX_EntryPermissions
FROM {databaseOwner}{objectQualifier}DMX_EntryPermissions ep
INNER JOIN {databaseOwner}{objectQualifier}DMX_Permissions p ON p.PermissionId=ep.PermissionId
WHERE p.PermissionKey='APPROVE'

You can optionally add 'AND p.PortalID=0' if you want to only delete approval on Portal 0.

Peter

PS Whenever doing direct SQL operations I suggest you backup the db just in case. It's quickly done and saves you a ton of work if things turn bad.