Module Discussions

Module Discussions

Problem with the new Permission Grid on fresh installs
Last Post 10/23/2009 03:17 PM by David O'Leary. 0 Replies.
Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
Please login to post a reply.
Author Messages
David O'Leary
Efficion Consulting Staff
Basic Member
Basic Member
Posts:151
Avatar

--
10/23/2009 03:17 PM
    For users who's first install was version 4.1.2 or greater, you'll experience problems if you enable the Approval process or want users (including admins) to be able to edit Articles other than their own.

    You are suppose to have two new columns in the permissions grid that let you control these options. But, the install code isn't working properly due to problems with the IUpgradable implementation and some other oddities with the DNN install process.

    We're working on a proper long term fix for this but for now, if you only have two columns (View Module, Edit Module) in the Module Permissions section under settings, then please run the following script through your Host -> SQL page:

    INSERT INTO {databaseOwner}{objectQualifier}Permission (PermissionCode, ModuleDefID, PermissionKey, PermissionName)
    SELECT 'Efficion_Articles', ModuleDefid, 'Approve', 'Approve Articles' FROM {databaseOwner}{objectQualifier}DesktopModules dm INNER JOIN {databaseOwner}{objectQualifier}moduledefinitions md on dm.DesktopModuleID = md.DesktopModuleID where ModuleName = 'Articles'
    GO

    INSERT INTO {databaseOwner}{objectQualifier}Permission (PermissionCode, ModuleDefID, PermissionKey, PermissionName)
    SELECT 'Efficion_Articles', ModuleDefid, 'EditOthers', 'Edit Others Articles' FROM {databaseOwner}{objectQualifier}DesktopModules dm INNER JOIN {databaseOwner}{objectQualifier}moduledefinitions md on dm.DesktopModuleID = md.DesktopModuleID where ModuleName = 'Articles'
    GO
    Please login to post a reply.