Question

Photo of Brandon Fuchs

0

Gaining Assess to Pages as Rock Admin when Restricted by Error.

1
I am the Admin for my organization's Rock System and during the early stages of my development I had another admin deny access to the RSR - Administrator to some of the out of box pages in both the external and internal site. I have since given that user a better set of security roles so that this won't happen again. Now I need to get myself back into these pages since no one else can? What is the easiest way to go about these. Two of the pages i'm locked out of are the Blog and the Watch Pages 
  • Photo of Jim Michael

    1

    The method I use when admin is locked out of a page is to run this SQL in the power tools:

    SELECT * FROM [Auth]    
    WHERE [EntityTypeId] = 2 AND EntityId = [PAGE NUMBER]

    Then: 

    DELETE FROM [Auth] WHERE [Id] = [ID OF RECORD RETURNED]

    The first query assumes you know the PAGE NUMBER of the page you need to reset rights on... plug that in (sans brackets) and you should get a record returned. Plug THAT record ID into the second query (again, sans brackets). Be SUPER careful with the second one as it's a DELETE query that is updating your db!

    • Jim Michael

      Jim Michael

      No, still works fine here. Are you making sure to set "Selection Query" on the SQL command to NO when running the DELETE FROM?