My Oracle Support Banner

E1: SEC: Frequently Asked Questions on Column Security (Doc ID 1073209.1)

Last updated on APRIL 05, 2024

Applies to:

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

Purpose

This document provides answers to frequently asked questions encountered with Column Security.

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 Column Security?
 Question 2: Before applying Column Security, should I verify the data item in the Data Dictionary to see if it allows this type of security?
 Question 3: How do I define Column Security for a certain application field?
 Question 4: Is it possible to apply Column Security for Business Functions or Reports?
 Question 5: What impact does Column Security have within an application?
 Question 6: When working with Column Security, what combination of the View, Add and Change options are allowed?
 Question 7: Is there a way to secure all fields on a form or all columns on a table by default in Column Security?
 Question 8: Can Column Security be used to secure Radio Buttons on a form?
 Question 9: What is the purpose of the JAS.INI setting UseRoleHierarchy?
 Question 10: How can I secure the Ship To Field, ALKY, in P4310 when the same data item is used for other different fields on the same form?
 Question 11: Are there any Audit Reports available that will print Column Security information?
 Question 12: Why does Column Security defined at the Table Level not work on Data Dictionary items on a form?
 Question 13: After creating or modifying Column Security, the security does not take affect?
 Question 14: How can column security be used to secure only one data item on a form when it is used in header and grid?
 Question 15: Column security with Add option on subform is not applied on form entry using Add button.
 Question 16: Column security applied on connected Static Text and Combo Box (both same alias) hides the combo box and leaves Static Text visible when form is in update mode.
 Question 17: How to apply column security in reusable form?
 Question 18: Same column security for same DD Alias works for 1 role but not for another role?
 Question 19: Is there an option to enable column security based on specific data in another column?
References

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