Data is not visible on the table even if the user has the roles

[shilpakamat]

Hi,

I have created a custom table with default read,write,create, delete ACLs. There are no additional ACLs on the table. When I impersonate a user with the role, he can see the table along with row count but all the fields are empty and I dont see any security contraint message as well. Any idea what could be wrong here ?

Thanks in Advance,

Shilpa

[Terry_Yeti]

Hey shilpakamat,

I ran your issue through snowcoder ai and it flagged a few common causes for this visibility problem. Here's what to check:

**1. Access Control Lists (ACLs)**
Even with the right roles, ACLs can block table access. Check:
- Navigate to System Security > Access Control (ACL)
- Filter by your table name
- Look for READ operations that might be restricting access
- Check if there are conditional ACLs with scripts that evaluate to false

**2. Data Policies**
These can hide fields or entire records:
- Go to System Policy > Data Policies
- Check if any apply to your table
- Look for "Read only" settings that might affect visibility

**3. UI Policies**
These can hide fields on forms:
- System UI > UI Policies
- Filter by your table
- Check if any are hiding fields for this user's role

**4. Query Business Rules**
These can filter out records before they're displayed:
- System Definition > Business Rules
- Look for "before query" business rules on your table
- They might be adding conditions that exclude records

**5. Record-level ACLs**
If you see some records but not others, check for field-level ACLs with conditions like:
```javascript
answer = (current.assigned_to == gs.getUserID());
```

**Quick Debug Steps:**
1. Impersonate the user (right-click their name > Impersonate)
2. Try to access the table directly via list view
3. Check the system logs (System Logs > System Log > All) for ACL denials
4. Use the Security Debug module (type "security_debug.do" in filter navigator)

Can you share which table this is happening on and what roles the user has? That'll help narrow down the issue.

_______________________________________
I used snowcoder ai to generate this. If you need to tweak the requirements, you can run it through their Yeti AI for free.