Search Results default_policy_type

Overview

The IGS_SC_OBJ_GROUPS table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, residing under the IGS (iGrants) product schema. It functions as a master repository for defining security object groups. As indicated by the ETRM documentation, its primary role is to store information related to Security User Attribute Values associated with user attributes. In essence, this table allows for the logical grouping of objects, which can then be collectively managed under a unified security policy. This is a fundamental component for implementing granular, attribute-based security controls within the application, enabling administrators to efficiently manage access permissions across related entities.

Key Information Stored

The table's design centers on a few critical columns that define and manage each object group. The primary identifier, OBJ_GROUP_ID, is a system-generated sequence number ensuring uniqueness. The most significant user-defined column is OBJ_GROUP_NAME, a mandatory 260-character field that holds the unique name of the security group as defined by an administrator. The DEFAULT_POLICY_TYPE column specifies the foundational security rule applied to the group, accepting values such as 'G' for Grant or 'R' for Restricted. Standard Oracle EBS "Who" columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) are present to track the audit trail of each record's creation and modifications.

Common Use Cases and Queries

This table is central to security administration and audit reporting. Common use cases include the initial setup and maintenance of security groups, auditing changes to group definitions, and troubleshooting security policy issues. A fundamental query to retrieve all defined object groups follows the pattern provided in the ETRM:

• Retrieve All Object Groups: SELECT OBJ_GROUP_ID, OBJ_GROUP_NAME, DEFAULT_POLICY_TYPE, CREATION_DATE, CREATED_BY FROM IGS.IGS_SC_OBJ_GROUPS ORDER BY OBJ_GROUP_NAME;
• Find a Specific Group by Name: SELECT * FROM IGS.IGS_SC_OBJ_GROUPS WHERE OBJ_GROUP_NAME = '&GROUP_NAME'; This is particularly relevant for searches involving the `OBJ_GROUP_NAME` field.
• Audit Recent Changes: SELECT OBJ_GROUP_NAME, DEFAULT_POLICY_TYPE, LAST_UPDATED_BY, LAST_UPDATE_DATE FROM IGS.IGS_SC_OBJ_GROUPS WHERE LAST_UPDATE_DATE > SYSDATE - 30;

Related Objects

As per the dependency information, the IGS_SC_OBJ_GROUPS table does not reference other objects but is itself referenced by objects within the APPS schema. This indicates it serves as a master lookup table. Its integrity is enforced by two unique indexes: IGS_SC_OBJ_GROUPS_PK on OBJ_GROUP_ID and IGS_SC_OBJ_GROUPS_UK on OBJ_GROUP_NAME, ensuring no duplicate group names exist. While the provided metadata does not list specific child tables, it is logically related to other security mapping tables within the IGS schema that associate these defined groups with specific objects, user attributes, and policies to enact the configured security model.