Sign in Register
Go to solution
Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Mikael Axel Kleinwort 140 posts 484 karma points c-trib
    May 13, 2022 @ 13:58
    Mikael Axel Kleinwort
    0

    Restoring Admin User rights

    Using Umbraco And Getting Started
    Umbraco 9

    Hello Umbracians,

    somehow in the Umbraco backend I managed to edit the Admin user role in such a way that all of my admin user accounts of this website now have no access to the "users", "packages" and "settings" backend tabs anymore.

    So I cannot edit the user roles anymore to get those tabs back :-)

    I have direct access to the database with SQL Server Management Studio on the server.

    Does anyone know what I can do in the database to restore the regular admin user group privileges?

    Thank you! Mikael

    Copy Link
  • Mikael Axel Kleinwort 140 posts 484 karma points c-trib
    May 15, 2022 @ 09:46
    Mikael Axel Kleinwort
    0

    Any input is appreciated very much! :-)

    Copy Link
  • Mikael Axel Kleinwort 140 posts 484 karma points c-trib
    May 19, 2022 @ 08:18
    Mikael Axel Kleinwort
    100

    I found out how to solve the problem and I am leaving the solution here in case anybody else manages to get into the same trouble :-)

    The database table to edit is umbracoUserGroup2App.

    The default content of this table is this:

    enter image description here

    After accidentally deleting the admin access for packages, settings etc., the table looks like this:

    enter image description here

    After adding the 4 missing records for userGrouId "1" and app "forms", "packages", "settings" and "users", and logging out of backend and back in, the problem was solved and full admin access restored.

    Copy Link
Please Sign in or register to post replies

Write your reply to:

Draft