Search Results fnd_grants




I'll provide a comprehensive description of the FND_GRANTS table in Oracle E-Business Suite (EBS):

Table Name: FND_GRANTS
Module: Foundation (FND)
Purpose: Stores security grant information for users and roles

Key Characteristics:
- Part of Oracle's Application Object Library (AOL)
- Manages application-level security and access permissions
- Tracks grant relationships between users, responsibilities, and applications

Typical Columns:
1. GRANT_ID (Primary Key)
- Unique identifier for each grant record
- Sequentially generated

2. GRANTEE_TYPE
- Identifies type of grantee (USER, RESPONSIBILITY)
- Determines who receives the grant

3. GRANTEE_KEY
- Key identifying specific user or responsibility
- References FND_USER or FND_RESPONSIBILITY

4. GRANTED_BY
- User who created the grant
- Often links to system administrator

5. GRANT_TYPE
- Defines type of permission (e.g., EXECUTE, VIEW)

6. OBJECT_TYPE
- Type of object being granted (e.g., FORM, REPORT)

7. OBJECT_NAME
- Specific object receiving the grant

8. START_DATE
- Effective start date of grant

9. END_DATE
- Expiration date of grant

Typical Use Cases:
- Managing user access to specific applications
- Implementing role-based security
- Controlling permission lifecycles
- Auditing security grants

Recommended Best Practices:
- Regularly review and clean up unnecessary grants
- Use least privilege principle
- Document grant rationales
- Monitor grant expirations