JDE Security

[Thorexocet]

Hi guys,

my company created a software which queries databases. We want to be able to query a JDE db with some security features. I have to find a way to know if a user has enough rights to access a table.

I know there are plenty of stuff in the 12 datadictionary tables, especially in the F00950 table, but I don't know how it works.

My objective is to know if a specific user has enough right to access a table and if he hasn't, then deny his request.

Do you have any idea or document on that particular point ?

Thank you for you help !
Antoine

 

[jjanowski]

I am understanding this is an external JDE application…

You will use the F00950. Query FSSETY = 4, where FSUSER = (Profile, Group/Roles, *PUBLIC). Table restricted is in FSOBNM, watch for *ALL's. Logic will also have to depend on Inclusive/Exclusive settings…

This will require complex logic where Row Security has to be interpreted correctly. My above notes are just a basic start…