BAQ Permissions

[lvanveghel (Leah Van Veghel)]

Good afternoon,

I have a couple of employees that would like to learn how to create queries, however, I have not found a way to limit the tables they have access to. Is there somewhere other than menu maintenance that permissions have to be updated for them to not have access to certain data like labor rates, GL activity, etc.? In testing this out it seems like any user that has BAQ access would have full access to all tables.

If the BAQ program would limit permissions to tables based on the employee’s menu access that would be ideal!

[Asz0ka (Adam Szoka)]

I think Field Security Maintenance is what you’re looking for. Here’s a post with some links to some other posts in it:

Better Field Security Management

The original reason for the creation of this screen was to help me create some read only access to the BAQ Designer screen for one of my users. I wanted to enable one of my current Power Users with access to the tables so she could better do her job, without having to much access to anything she didn’t need. After seeing some need in the community I expanded upon it to work in a variety of ways. This is not an official Epicor product and is to be used AT YOUR OWN RISK. I will not be responsible…

[lvanveghel (Leah Van Veghel)]

That looks like it could take some time to set-up! I have worked in Field Security Maintenance before but will have to give this a closer look.

Thanks for taking the time to share!