DNN Forums

Ask questions about your website to get help learning DNN and help resolve issues.
Prev
Next

Admin user cannot access Assets folders

Forums > Administration and Configuration
Sort:
You are not authorized to post a reply.





David Fenske

New Around Here



Posts:27
New Around Here




4/28/2022 3:59 PM

    I remember this being a problem in older versions of DNN - Even Admin members would have problems getting into Folders to add or use images. I used to be able to just go to the (Telerik) File Manager, right click the root level folder, make some permission change and save, cascade those down to other folders and it would fix the issue, even if there was no actual permission change. 

    Now with the new Resource Manager, I do see a place to set permissions, but not to inherit those down to other folders. I tried adding permissions for this user as an individual, and it just gives and error message.

    Is there a way to manage or fix this in the DNN tables in SQL?

    Thanks! David






    Chris Hammond

    Growing Member



    Posts:51
    Growing Member




    5/10/2022 9:17 AM
      Flashbacks to this one.... I feel like this was linked to a problem where the Admin role id was different? Been so many years, not sure where to look for that nowadays. Possibly portal settings

      As for forcing perms down, not sure on the newer RM either
      Chris Hammond Christoc.com Software Solutions
      With DNN since before it was DNN!
      Open Source Projects and Tutorials since 2003





      alexismaria

      New Around Here



      Posts:24
      New Around Here




      5/26/2022 11:02 AM
        I have had a recent problem with being able to access the root folder when I tried to link a document it didn't cascade at all. and it just showed the ROOT as a folder that wouldn't open. I am the host-superuser. 9.10.01 version being used.
        It occurs randomly.





        Timo Breumelhof (40F)

        Veteran Member



        Posts:1094
        Veteran Member




        7/11/2022 5:55 AM

          I had the same issue and found a script to correct this from the excellent DNN Turbo Scripts by Sebatain Leupold:

          https://github.com/dnnwerk/dnnScript

          I used this:

          MERGE INTO [FolderPermission] X
          USING (SELECT F.FolderID, R.PermissionID, P.AdministratorRoleId AS RoleID
                  FROM       [Folders]    F
                  JOIN       [Portals]    P ON F.PortalID = P.PortalID
                  CROSS JOIN [Permission] R
                  WHERE R.PermissionCode LIKE N'SYSTEM_FOLDER') S ON X.FolderID = S.FolderID AND X.PermissionID = S.PermissionID AND X.RoleID = S.RoleID
           WHEN MATCHED AND AllowAccess = 0 Then UPDATE SET AllowAccess = 1
           WHEN NOT MATCHED THEN INSERT (  FolderID,   PermissionID, AllowAccess, RoleID, UserID, CreatedByUserID, CreatedOnDate, LastModifiedByUserID, LastModifiedOnDate)
                                 VALUES (S.FolderID, S.PermissionID,         1, S.RoleID,   Null,              -1,     GetDate(),                   -1,          GetDate());
          GO

           

          40FINGERS Web Solutions · Style Helper · DDR Menu Demo Skins · SEO Redirect





          David Fenske

          New Around Here



          Posts:27
          New Around Here




          7/11/2022 11:51 AM

            Thanks so much, Timo!  I'll give this a try!

            David






            Michael Tobisch

            Veteran Member



            Posts:1124
            Veteran Member




            7/12/2022 9:16 AM
              David,

              don't forget to backup the database before you try it... (just in case something goes wrong)

              Happy DNNing!
              Michael

              Michael Tobisch
              DNN★MVP

              dnnWerk Austria
              DNN Connect





              Aderson Oliveira

              New Around Here



              Posts:2
              New Around Here




              10/12/2022 1:25 PM

                This problem seems to be gone with the upgrade to DNN 9.11






                David Fenske

                New Around Here



                Posts:27
                New Around Here




                10/12/2022 4:16 PM

                  Awesome to hear that, Aderson! I saw something about permissions mentioned in the release notes and wondered if that was the same issue. Thanks for sharing.

                  You are not authorized to post a reply.

                  These Forums are dedicated to the discussion of DNN Platform.

                  For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

                  1. If you have (suspected) security issues, please DO NOT post them in the forums but instead follow the official DNN security policy. 
                  2. No Advertising. This includes the promotion of commercial and non-commercial products or services which are not directly related to DNN.
                  3. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
                  4. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
                  5. No Flaming or Trolling.
                  6. No Profanity, Racism, or Prejudice.
                  7. Site Moderators have the final word on approving / removing a thread or post or comment.
                  8. English language posting only, please.

                  Would you like to help us?

                  Awesome! Simply post in the forums using the link below and we'll get you started.

                  Get Involved