Search Results user_attrib_id




Overview
Explore in AI Chat

Overview

The IGS_SC_USR_ATT_VALS table is a core data repository within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the IGS (Oracle's Student Management System) product family. Its primary role is to store the specific values assigned to user-defined security attributes for individual application users. This table functions as the intersection point between a defined security attribute, a system user, and the concrete value for that attribute. The data stored here is critical for implementing and enforcing fine-grained, attribute-based security rules and data access controls within the application, enabling personalized user experiences and secure data segmentation.

Key Information Stored

The table's structure is designed to map users to their attribute values efficiently. The key columns include:

  • USER_ATTRIB_ID: A mandatory foreign key that references the IGS_SC_USR_ATTRIBS table. This column identifies the specific security attribute definition to which the value belongs.
  • USER_ID: A mandatory foreign key that references the FND_USERS table. This column identifies the application user for whom the attribute value is set.
  • ATTR_VALUE: A VARCHAR2 field holding the actual value (up to 2000 characters) for the specified user and attribute. This value is dynamically retrieved and evaluated during security checks.
  • Standard Who Columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN): These audit columns track the creation and modification history of each record, adhering to Oracle EBS standards.
The unique primary key constraint (IGS_SC_USR_ATT_VALS_PK) on USER_ID, USER_ATTRIB_ID, and ATTR_VALUE ensures that a user can have only one specific value recorded for a given attribute, though different values for the same user-attribute combination are permitted as separate records.

Common Use Cases and Queries

This table is central to security and reporting operations. A primary use case is troubleshooting and auditing user security profiles. Administrators can query this table to verify which attribute values are assigned to a specific user or to list all users assigned a particular attribute value for security analysis. Common SQL patterns include retrieving all attribute values for a given user or finding all users with a specific attribute setting. For example, to audit values for a user with ID 1234, the query would be: SELECT uat.USER_ATTRIBUTE_NAME, val.ATTR_VALUE FROM IGS_SC_USR_ATT_VALS val, IGS_SC_USR_ATTRIBS uat WHERE val.USER_ATTRIB_ID = uat.USER_ATTRIB_ID AND val.USER_ID = 1234;. This data is also essential for custom reports that need to segment data based on user security attributes, such as generating department-specific lists or role-based dashboards.

Related Objects

The IGS_SC_USR_ATT_VALS table exists within a defined dependency hierarchy. It is a child table that depends on two key parent tables:

  • IGS_SC_USR_ATTRIBS: Provides the definition and metadata for the security attribute via the USER_ATTRIB_ID foreign key.
  • FND_USERS: Provides the core application user identity via the USER_ID foreign key.
According to the provided metadata, the table itself is referenced by an object within the APPS schema named IGS_SC_USR_ATT_VALS, which is likely a public synonym or a view that facilitates application access. The table's design, with its indexed columns (USER_ATTRIB_ID, USER_ID), is optimized for the typical access patterns of joining to these parent tables and looking up values by either user or attribute.