FND Design Data [Home] [Help]

Table: JTF_AUTH_READ_PERMS

Product: JTF - CRM Foundation
Description: Is the denormalized table that maps every user [JTF_AUTH_PRINCIPAL_NAME] to a permission [JTF_AUTH_PERMISSION_NAME] for a given domain [JTF_AUTH_DOMAIN_NAME]
Implementation/DBA Data: TableJTF.JTF_AUTH_READ_PERMS
Primary Key: JTF_AUTH_READ_PERMS_PK
  1. ColumnJTF_AUTH_READ_PERMISSION_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JTF_AUTH_READ_PERMS FK Joins to TableJTF_AUTH_PRINCIPALS_B JTF_AUTH_READ_PERMS.JTF_AUTH_PRINCIPAL_ID
JTF_AUTH_READ_PERMS FK Joins to TableJTF_AUTH_PERMISSIONS_B JTF_AUTH_READ_PERMS.JTF_AUTH_PERMISSION_ID
JTF_AUTH_READ_PERMS FK Joins to TableJTF_AUTH_DOMAINS_B JTF_AUTH_READ_PERMS.JTF_AUTH_DOMAIN_ID