Skip to main content
Question

Generic Inquiry for a User with Screen access.

  • February 28, 2025
  • 3 replies
  • 43 views
R
Captain II
Forum|alt.badge.img+2

I'm working on creating a generic inquiry for users that displays their screen access rights in Acumatica such as Revoked, Delete, etc.—but I haven't been able to fine any table that stores this data. Has anyone attempted this before?

🚀If I have helped you, "Like" my post. If it solves it mark "Best Answer". 🚀

3 replies

BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • February 28, 2025

​@ranjithduraisamy72 There are two reports in the User Security module, Access Rights by Role/Screen, and User List (which displays users and all their roles). You should be able to check the tables used on these reports and build your own which contains users/roles/access.

Chris Hackett
R
Captain II
Forum|alt.badge.img+2

​@BenjaminCrisman Thanks for the reply.

I tried based on your suggestion, but I dont see any table to link the User with the tables defined in that report.

🚀If I have helped you, "Like" my post. If it solves it mark "Best Answer". 🚀
BenjaminCrisman
Acumatica Employee
Forum|alt.badge.img+4
  • BenjaminCrisman
  • Acumatica Support Team
  • February 28, 2025

​@ranjithduraisamy72 You’re right, they are not using normal access tables in the Access Rights report. Probably need to use Users or UsersInRoles table in conjunction with RolesInGraph table

Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved