• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

query user access rights/roles via database

scottwil

Member
Hi,

Does anyone know if we can pull out user access roles from E1 via database queries?

We are looking for 2 things. The easy should be which users have which roles and the role description.

The other thing we would ideally like is the role access by module. For each role, which level of access (add/change/inquiry) does it give you on which module (addressbook/ap/ar/etc...)

Can those be pulled via database and is anyone willing to share the queries you used?

Thank you!!

Scott
 

peterbruce

Legendary Poster
Scott,

F0092 is the user profile table. It also contains the Role IDs
F00926 contains Role descriptions
F95921 is the role assignment/relationship table
F00950 is the security workbench.

Those tables should provide you with what you need - unless you also use menus to control access to functionality as well.
 

jdedwardsuser

Active Member
Perfect answer by Peter .
To add - In F00950 , you can go by security type , like 3 for application security . 1 is for action . 5 for processing option and data selection . 2 for column 4 for row and so on .. OBNM has the object name . DTAI will have the data item for column security . FRDV can have the version or it can have ranges for row . There are fields all in F00950 for every security type and Y N etc
 

scottwil

Member
Thank you both. That sounds like it will have everything we need. Are those tables that you can query via a direct SQL query, not using the product at all?

Thank you!
 
Top