Field security: is there a report showing which field has security applied?

[Hogardy (Pierre Hogue)]

Hello,

We are testing Field security, and I was wandering how can I view the results of the configuration. I did not find a report showing me the list of fields which had security applied to.

I have multiple fields to apply this and wanted to have a list of fields having this security applied to, in order to confirm I did not miss one…

Thanks
Pierre

[chaddb (Chadd Blanchard)]

Not aware of any built-in report for field security. I have a test user that isn’t hooked into SSO that I test field security with.

[chaddb (Chadd Blanchard)]

Here is a thread talking about field security from a couple years ago. Never tried anything mentioned here but some good info maybe. Few other threads are linked to this one.

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…

[Mark_Wonsil]

@Hogardy

was wandering how can I view the results of the configuration.

Field Security is stored in the Ice.SecColumn table.

Service Security is stored in the Ice.Security table.

[Hogardy (Pierre Hogue)]

Yes I have found that and was a bit disapointed. The table is missing the Group (or user if setup that way) that was assigned to the Field security line. Also would want to see Who did this entry eventually…
(but that can be done via UD fields… probably…)

So here my test was do not allow view of Part.PartDescription to users part of a specific Group.
It worked fine.
here is the table content:

As you can see the Denylist is empty… would have expected to see my group denying access…

Pierre

[Mark_Wonsil]

@Hogardy

would have expected to see my group denying access…

Me too.

And it’s working???

[Hogardy (Pierre Hogue)]

Yep like a charm!!!
Everywhere the user sees PartDescription, it is showing as an empty grey square…

But this time I denied it not to a group, but a specific user (1615) and guess what… the user appears in the list…

go figure!

Pierre

[Hogardy (Pierre Hogue)]

So I cannot know which group was assigned the deny… and we work exclusively with sec groups !!!

is it a bug…?

Pierre