Results 1 to 2 of 2

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

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.