Search Results ibc_grant_groups




Overview
Explore in AI Chat

Overview

The IBC_GRANT_GROUPS table is a core data object within the Oracle E-Business Suite Content Manager (IBC) module, present in both the 12.1.1 and 12.2.2 releases. It functions as a master repository for defining logical collections of security permissions, known as grant groups. These groups serve as a central mechanism for managing and applying access control policies to various content objects within the system. By grouping individual grants, the table enables administrators to efficiently assign complex, reusable security profiles to users, responsibilities, or other entities, thereby streamlining the administration of content-level security across the application.

Key Information Stored

The primary data stored in this table centers on the identification and definition of each grant group. The key column is the GRANT_GROUP_ID, which serves as the unique primary key identifier for each group. While the provided ETRM metadata does not list additional columns, a typical implementation for such a table would also include standard Oracle EBS columns for tracking creation and modification dates (CREATION_DATE, LAST_UPDATE_DATE), the responsible user IDs (CREATED_BY, LAST_UPDATED_BY), and a column for the name or description of the grant group (e.g., GRANT_GROUP_NAME). The GRANT_GROUP_ID is the critical piece of data used to link the group to its constituent grants and the objects to which it is applied.

Common Use Cases and Queries

The primary use case for the IBC_GRANT_GROUPS table is the bulk administration of content security. An administrator can create a grant group for a specific project or role, populate it with individual permissions via the IBC_GRANTS table, and then assign that entire set of permissions to multiple content objects or users in a single operation. Common reporting and diagnostic queries involve identifying all grants within a specific group or finding which grant groups are applied to a particular content object. A sample SQL pattern to list grant groups and a count of their associated grants would be:

  • SELECT gg.GRANT_GROUP_ID, COUNT(g.GRANT_ID) AS GRANT_COUNT FROM IBC_GRANT_GROUPS gg, IBC_GRANTS g WHERE gg.GRANT_GROUP_ID = g.GRANT_GROUP_ID GROUP BY gg.GRANT_GROUP_ID;

Related Objects

The IBC_GRANT_GROUPS table maintains defined foreign key relationships with two other critical tables in the IBC security model, as documented in the ETRM metadata:

  • IBC_GRANTS: This table stores the individual permission records. It references IBC_GRANT_GROUPS via the column IBC_GRANTS.GRANT_GROUP_ID. This relationship defines which specific grants belong to a logical group.
  • IBC_OBJECT_GRANT_GROUPS: This table is used to associate grant groups with specific content objects. It references IBC_GRANT_GROUPS via the column IBC_OBJECT_GRANT_GROUPS.GRANT_GROUP_ID, linking the security profile to the secured entity.

Together, these relationships form the structural backbone for applying grouped security policies within the Oracle EBS Content Manager.