Results 1 to 3 of 3

Thread: query user access rights/roles via database

  1. #1

    query user access rights/roles via database


    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!!


  2. #2
    Senior Member peterbruce's Avatar
    Join Date
    Jan 2004
    NSW Australia

    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.
    Thanks, Peter

    "Give a person a fish, feed them for a day, teach them how to fish, feed them for a lifetime."

    E9.1 TR9.1.2.1, Enterprise Server: Sun, Database Server: Sun, Oracle DB: 11g, Weblogic.
    Create!form 7

  3. #3
    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.