Discussions

Expand all | Collapse all

Users Receiving Permission Denied Messages for Data That They Should Be Allowed to See

  • 1.  Users Receiving Permission Denied Messages for Data That They Should Be Allowed to See

    Posted 12-12-2017 12:09
    I am seeing issues with permissions following data warehouse move - it is where form data visibility is limited by user 


  • 2.  RE: Users Receiving Permission Denied Messages for Data That They Should Be Allowed to See

    Posted 12-12-2017 12:45
    More info - 

    In a realationship   Items -> Child Items -> Grandchild Items

    A user creates an item, some child items for that item and some grandchild items for the top level item. 

    That user is only allowed to see data based on them being the Created By in the top level Items table.

    This was limited in the table using Access settings for the Child and Grandchild tables by

    when user is  Items - Created by

    The error we are seeing is that the user can see data in Child but not in Grandchild, however if I set the access in Grandchild to 

    when user is Child - Items - Created by  (a lookup field from the parent Items table)

    they can see the data without any problem.


  • 3.  RE: Users Receiving Permission Denied Messages for Data That They Should Be Allowed to See

    Posted 12-12-2017 12:55
    My guess is that you may have made a relationship which skipped a generation from Items to Grandchild, but it is not being populated. 

    You can probably delete that relationship and double hop any lookup fields down though the child to the grandchild.

    You should make copy of your app first before deleting any relationship if you are not sure if you need it.  ie test before deleting.


  • 4.  RE: Users Receiving Permission Denied Messages for Data That They Should Be Allowed to See

    Posted 12-12-2017 13:26
    Possibly that is the case - but this is a case of the relationship having been working as of Friday and no longer working today (we had a power outage due to weather yesterday).


  • 5.  RE: Users Receiving Permission Denied Messages for Data That They Should Be Allowed to See

    Posted 12-12-2017 13:36
    I doubt a local power failure or the Quick Base data center move is the cause.


  • 6.  RE: Users Receiving Permission Denied Messages for Data That They Should Be Allowed to See

    Posted 12-12-2017 13:40
    It does look like the relationship isn't being populated any more - am currently investigating possible causes.


  • 7.  RE: Users Receiving Permission Denied Messages for Data That They Should Be Allowed to See

    Posted 12-12-2017 13:43
    Once again I would question the purpose of that relationship.  I would just double hop the lookup fields down to the child and from there down to the Grand Child and kill off that relationship which skips a generation.


  • 8.  RE: Users Receiving Permission Denied Messages for Data That They Should Be Allowed to See

    Posted 12-12-2017 14:09
    I'm also seeing an issue in another app - where lookup fields from a relationship appear to have the wrong field names.


  • 9.  RE: Users Receiving Permission Denied Messages for Data That They Should Be Allowed to See

    Posted 12-12-2017 14:27
    Hi Ian,

    If you are still having issues finding the reason your records aren't syncing up correctly I would recommend opening a case with our Customer Care Team. This way they can help you isolate the source of the issue. While signed into Quick Base if you click Help > Manage Support Cases > + New Support Case you can create a case with our Customer Care Team and they can help you to find where the disconnect is happening. 


  • 10.  RE: Users Receiving Permission Denied Messages for Data That They Should Be Allowed to See

    Posted 12-12-2017 14:30
    Thanks Evan - will do