Access to records is not same when impersonated.

[Chindam Priyank]

when one user (X) can see records in a table, but when another user (Y) impersonates X, the records are not visible and a security constraint error occurs, suggests that there may be specific access or permissions set for user X that are not being properly applied during the impersonation.

The table is not global but Security Incident Response application.

[Ankur Bawiskar]

@Chindam Priyank 

the access should be same even if someone impersonates or that user actually logs in.

[Chindam Priyank]

Hello ankur,

Thank for your response.

But in our case the user is able to view only few records let say 500 number of records when impersonated but the actual user is able to view all records i.e 1000 records.

[Chindam Priyank]

Here is screenshot this is how user is able to view

But when the same user is impersonated by other user this error we are getting.

Kindly suggest

[Siddhesh Gawade]

Hello @Chindam Priyank ,

Even if we impersonate someone, the access should be the same. So please check existing ACLs on table, and check which ACLs are not allowing the access. You can use SNOW's Debug security option to find the ACLs.

Also check the if there any conditions are being checked using script in your ACLs. That may be the issue.

Kindly mark the answer ✔️Correct or Helpful ✔️If it addresses your concern.

Regards,

Siddhesh