My Oracle Support Banner

E1: SEC: Frequently Asked Questions on Roles and Security (Doc ID 1087848.1)

Last updated on NOVEMBER 30, 2021

Applies to:

JD Edwards EnterpriseOne Tools - Version SP24 and later
Information in this document applies to any platform.


This document provides answers to frequently asked questions regarding the use of roles in Security Workbench.

Questions and Answers

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Questions and Answers
 Question 1: What is a Role, where is it defined and in which table is the role information stored?
 Question 2: What is the purpose of the Sequence Number when adding a Role?
 Question 3: How do you look up the order of the roles within the Role Hierarchy?
 Question 4: Why, after upgrading from 8.12 to 9.0, some roles which had high sequence number in 8.12 now have low role sequence number in 9.0?
 Question 5: What is a Role Relationship and where is it defined?
 Question 6: Can I set up a role for a consultant who needs access to EnterpriseOne for a limited period of time?
 Question 7: What is the meaning of the option "Include in *ALL" when setting up a role relationship?
 Question 8: Is there a way to remove the *ALL role from appearing as an option during sign-on?
 Question 9: How many roles can be assigned to a user?
 Question 10: What is considered a Security Conflict and how is it resolved?
 Question 11: How is Security applied with Roles?
 Question 12: Why does *ALL Object Security at the Role Level Result in Security Conflicts?
 Question 13: How does the changing of roles affect security after the user has initially signed on with *ALL?
 Question 14: Security defined for a specific role is not applied when the user signs on with the *ALL role?
 Question 15: Does the security set on a specific object always override the security set on *ALL objects within the same role?
 Question 16: In Security Workbench, is it possible to merge the security information from multiple existing roles into a single role?
 Question 17: What is the purpose of the JAS.INI setting UseRoleHierarchy?
 Question 18: How can I produce a report that shows all users assigned to a role?
 Question 19: How do I find the list of roles assigned to a user?
 Question 20: Why does the user receive a security error when attempting to select the Delete/Remove Role action as they have already been defined with Delete Action Security?
 Question 21: Why is a role still deleted when a secured user clicks on the Remove Role icon even though Application Security is defined and the user correctly receives the security error?
 Question 21: Which tables are affected when a Role is deleted in P0092?
 Question 22: How to rename an existing role?
 Question 23: Can a new role be created and assigned as a sub-role to an existing role?
 Question 24: How are role relationships deleted/removed?
 Question 25: Why do roles get corrupted?

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.