Search Results jtf_auth_role_perms_pk
Overview
The JTF_AUTH_ROLE_PERMS table is a core authorization entity within the Oracle E-Business Suite CRM Foundation (JTF) module. It functions as a junction table that defines the relationship between security roles and the specific permissions they are granted or denied. In the context of the EBS security model, roles are a type of principal, representing a group of users or a job function. This table is critical for implementing a flexible, rule-based access control system where permissions can be explicitly allowed (positive) or prohibited (negative) for a given role, enabling complex security policies.
Key Information Stored
The table's primary data establishes the link between a principal (role), a permission, and the application context. The key columns include JTF_AUTH_ROLE_PERMISSION_ID (the primary key surrogate identifier), JTF_AUTH_PRINCIPAL_ID (foreign key to JTF_AUTH_PRINCIPALS_B, identifying the role), and JTF_AUTH_PERMISSION_ID (foreign key to JTF_AUTH_PERMISSIONS_B, identifying the specific permission). The APPLICATION_ID column ties the assignment to a specific EBS application module via FND_APPLICATION. The most critical business rule column is POSITIVE_FLAG, which dictates whether the linked permission is granted (typically 'Y') or explicitly denied (typically 'N') for the associated role.
Common Use Cases and Queries
A primary use case is security auditing and troubleshooting, such as identifying all permissions assigned to a specific role or determining which roles grant a particular permission. Developers and administrators query this table to understand the effective security matrix. A common pattern is joining to principal and permission descriptive tables to translate IDs into meaningful names. For example, to list all positive permissions for a role named 'CRM_MANAGER', one might use a query joining JTF_AUTH_PRINCIPALS_B for the role name, JTF_AUTH_PERMISSIONS_B for the permission name, and filtering on POSITIVE_FLAG = 'Y'. Another critical use case is during the evaluation of a user's cumulative permissions, where the authorization engine aggregates and reconciles all positive and negative permissions from all roles assigned to the user.
Related Objects
The table maintains defined foreign key relationships with several other core authorization tables, as documented in the ETRM metadata. These relationships are fundamental to its integrity and function:
- JTF_AUTH_PRINCIPALS_B: Joined via JTF_AUTH_PRINCIPAL_ID. This table stores the definition of the principal (the role) itself.
- JTF_AUTH_PERMISSIONS_B: Joined via JTF_AUTH_PERMISSION_ID. This table stores the definition of the individual permission being granted or denied.
- FND_APPLICATION: Joined via APPLICATION_ID. This standard EBS table provides the application context (e.g., JTF, FND) for the permission assignment.
-
Table: JTF_AUTH_ROLE_PERMS
12.1.1
owner:JTF, object_type:TABLE, fnd_design_data:JTF.JTF_AUTH_ROLE_PERMS, object_name:JTF_AUTH_ROLE_PERMS, status:VALID, product: JTF - CRM Foundation , description: This table groups roles [which are a type of principals] to permissions. Permissions can be positive or negative, based on the column POSITIVE_FLAG. , implementation_dba_data: JTF.JTF_AUTH_ROLE_PERMS ,
-
Table: JTF_AUTH_ROLE_PERMS
12.2.2
owner:JTF, object_type:TABLE, fnd_design_data:JTF.JTF_AUTH_ROLE_PERMS, object_name:JTF_AUTH_ROLE_PERMS, status:VALID, product: JTF - CRM Foundation , description: This table groups roles [which are a type of principals] to permissions. Permissions can be positive or negative, based on the column POSITIVE_FLAG. , implementation_dba_data: JTF.JTF_AUTH_ROLE_PERMS ,
-
eTRM - JTF Tables and Views
12.2.2
description: Interface table to store data that needs to be displayed in Excel ,
-
eTRM - JTF Tables and Views
12.1.1
description: Interface table to store data that needs to be displayed in Excel ,
-
eTRM - JTF Tables and Views
12.2.2
description: Interface table to store data that needs to be displayed in Excel ,
-
eTRM - JTF Tables and Views
12.1.1
description: Interface table to store data that needs to be displayed in Excel ,