FND Design Data [Home] [Help]

Table: JTF_AUTH_PERMISSIONS_B

Product: JTF - CRM Foundation
Description: This table will store the permissions [which are simple strings] for all the domains in the system. We will partition the permissions by applicationID for hosting purposes.
Implementation/DBA Data: TableJTF.JTF_AUTH_PERMISSIONS_B
Primary Key: JTF_AUTH_PERMISSIONS_PK
  1. ColumnJTF_AUTH_PERMISSION_ID
Primary Key: JTF_AUTH_PERMISSIONS_UK1
  1. ColumnPERMISSION_NAME
Primary Key: JTF_AUTH_PERMISSIONS_UK2
  1. ColumnPERMISSION_DESC_ID
Foreign Keys
Table
Foreign Table Foreign Key Column
JTF_AUTH_PERMISSIONS_B FK Joins to TableFND_APPLICATION JTF_AUTH_PERMISSIONS_B.APPLICATION_ID
TableJTF_AUTH_PERMISSIONS_TL FK Joins to JTF_AUTH_PERMISSIONS_B JTF_AUTH_PERMISSIONS_TL.PERMISSION_DESC_ID
TableJTF_AUTH_READ_PERMS FK Joins to JTF_AUTH_PERMISSIONS_B JTF_AUTH_READ_PERMS.JTF_AUTH_PERMISSION_ID
TableJTF_AUTH_ROLE_PERMS FK Joins to JTF_AUTH_PERMISSIONS_B JTF_AUTH_ROLE_PERMS.JTF_AUTH_PERMISSION_ID
TableJTF_DAC_ROLE_PERM_CRIT FK Joins to JTF_AUTH_PERMISSIONS_B JTF_DAC_ROLE_PERM_CRIT.JTF_AUTH_PERMISSION_ID