My Oracle Support Banner

E1: SEC: Frequently Asked Questions on Row Security (Doc ID 1078989.1)

Last updated on NOVEMBER 22, 2019

Applies to:

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

Purpose

This document details many of the frequently asked questions on Row Security and the answers to these questions.  

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
Purpose
Questions and Answers
 Question 1: What is Row Security?
 Question 2: Where can I find additional information on Row Security?
 Question 3: What is the difference between Inclusive and Exclusive Row Security?
 Question 4: Where do I define in the system whether I am using Inclusive or Exclusive Row Security?
 Question 5: Are there certain tables in EnterpriseOne where Row Security cannot be applied?
 Question 6: If no Row Security is defined for a User/Role or *PUBLIC, what access does the user/role have to data within the tables?
 Question 7: I am getting an error of "Data Item not setup for Row Security" when attempting to define Row Security for a specific data item?
 Question 8: How do I define access to a blank value when defining Row Security?
 Question 9: Is it possible to set up row security for all values instead of using a range?
 Question 10: After creating or modifying Row Security, why does the security not take affect?
 Question 11: After making a Data Dictionary change to allow for Row Security, the change does not take effect on the Web Client even after I clear the cache?
 Question 12: How is Row Security defined at the Role Level applied when signing on as *ALL?
 Question 13: What issues can be encountered when defining Row Security for *ALL tables?
 Question 14: After defining Row Security for Business Unit (MCU) on *ALL Tables, why do I receive AAI Errors?
 Question 15: How can I define row security to prevent posting of batches? 
 Question 16: Is it valid to apply Row Security on the F98OWSEC User Security Table?
 Question 17: How do I troubleshoot Row Security?
 Question 18: Are there any Audit Reports available that will print Row Security information?
 Question 19: After row security has been applied, why do users get different results in an Interactive Application as compared to a Report run on the Server
 Question 20: With Row Security applied to Search Type, why are my users still able to make changes to Addresses and Phones for secured Search Types?
 Question 21: What is the purpose of the P95300 Business Unit Security Maintenance application?
 Question 22: How do I evaluate whether I have correctly defined the range of From and Thru values for row security on Business Unit?
 Question 23: Can the Row Security defined for the Add and Update actions be different?
 Question 24: Is there a Maximum Number of Row Security Records that can be Defined for a User/Role?
 Question 25: Why is a user getting a Business Function error on row security instead of a security error?
 Question 26: Row Security on AN8 Causes Havoc with E1
 Question 27: Why are row security violation error messages written to the log file and not displayed?
 Question 28: Is it possible to use a wild card (*) in "From Value" and "Thru Value" fields for EnterpriseOne Row Security configuration?
 Question 29: What is the system or performance impact of enabling Row Level Security?
 Question 30: Why does an update to table F0101 not throw an error with row security enabled in TR 9.2 as in TR 8.98 where it throws ""File can not be accessed" error when row security is enabled? In what scenarios would the pop-up error message be displayed for row security violations and in what scenarios are the errors written only to the logs with no pop-up errors in TR 9.2?
References

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