Granting Role-based upload access to CKEditor


In this article, we will explain how to grant role-based upload access to the CKEditor using only the Database access and the XML configuration file. 

This procedure is very useful when the customer doesn't have access to the HTML Editor Manager.

Step-By-Step Guide

  1. Open the SQL Console
  2. Run the following query

    select RoleID from Roles where RoleName like '<RoleName>'
    • Replace <RoleName> with the name of the role that you want to grant access to the CKEditor. 
  3. Run the following query.

    INSERT INTO CKE_Settings (SettingName, SettingValue) VALUES ('DNNCKP#<PortalId>#uploadfileRoles#<RoleID>', -1)
    • Replace <PortalId> with your PortalID.
    • Replace <RoleID> with the ID collected on step 2. 

  4. Clear the server cache
  5. Access the Windows Server that host the DNN portal. 
  6. Navigate to your portal folder and go the folder containing the portal that you want to edit. (Portal folder/Portal ID folder
  7. Open the Dnn.CKEditorSettings.xml file. 
  8. Search for the following string "<BrowserRoles>0;Administrators;</BrowserRoles>". 
  9. Append the RoleID to the BrowserRoles node

    • Example, if the role that you want to add has Role ID 4; Your node should look like this: 

  10. Save the file
  11. Access the CKEditor using the updated role to make sure that the change was correctly applied. 




Please sign in to leave a comment.