Question

Photo of Andrew Lee

0

Locked out of external website

3

I'm embarrased to admit how it happened -- but in doing some updates to our website the domainname/page/1 is now innaccessible.  The security settings were modified on that page to be all users deny for view access.

Is there anyway to revert this?  Please help!

Thank you!

Andrew

  • Photo of Jon Edmiston

    0

    At this point you're pretty much at the SQL level. Put this into the SQL tool in Rock (Admin Tools > Power Tools > SQL Command)

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

    This should show you the rules for that page. If everything looks as you expect you can delete the offending rule. If you'd like you can post the results here and I and confirm what to delete for you.

  • Photo of Andrew Lee

    0

    Hi Jon,

    Here is the output

    Id Entity Type Id Entity Id Order Action Allow Or Deny Special Role Group Id Guid Created Date Time Modified Date Time Created By Person Alias Id Modified By Person Alias Id Foreign Key Person Alias Id Foreign Guid Foreign Id
    2628 2 1 0 View D 1   c57291ce-b123-4975 3/16/2016 5:39 AM 3/16/2016 5:39 AM 267 267        
  • Photo of Jon Edmiston

    0

    OK good that is what I would expect. You can use the query below to delete the rule then refresh your cache.

    DELETE FROM [Auth] WHERE [Id] = 2628