Patrickjk
Active Member
My employer is currently upgrading from JDE 7.3.3.3 to 9.2. NOTE: I am a developer, but I believe this is the correct forum to pose my question.
1) I created a new custom table F55XXXXX in 9.2 via the Table Design Aid. I generated the table and the indexes.
2) There are currently 3 JDE 9.2 DB Users - JDE, JDER, and JDEX.
3) All JDE users assigned to DB User JDE have access to table F55XXXXX because DB User JDE has the JDEADMIN role assigned to it whereas JDER and
JDEX do not have the JDEADMIN role, so any JDE users assigned to DB Users JDER and JDEX did/do not have access to this table.
4) I had the DBA add the table to one of the roles assigned to both DB Users JDER and JDEX. Now all JDE Users have access to table F55XXXXX.
5) I've never had to have a DBA add a table to any of the DB users in JDE 7.3.3.3 to grant access which leads me to the following question...
Is there possibly a system table in JDE where a record has to be created for each DB User, so the Table Design Aid knows to grant access to the DB Users for any tables that are generated?
Any help would be greatly appreciated.
Patrick
1) I created a new custom table F55XXXXX in 9.2 via the Table Design Aid. I generated the table and the indexes.
2) There are currently 3 JDE 9.2 DB Users - JDE, JDER, and JDEX.
3) All JDE users assigned to DB User JDE have access to table F55XXXXX because DB User JDE has the JDEADMIN role assigned to it whereas JDER and
JDEX do not have the JDEADMIN role, so any JDE users assigned to DB Users JDER and JDEX did/do not have access to this table.
4) I had the DBA add the table to one of the roles assigned to both DB Users JDER and JDEX. Now all JDE Users have access to table F55XXXXX.
5) I've never had to have a DBA add a table to any of the DB users in JDE 7.3.3.3 to grant access which leads me to the following question...
Is there possibly a system table in JDE where a record has to be created for each DB User, so the Table Design Aid knows to grant access to the DB Users for any tables that are generated?
Any help would be greatly appreciated.
Patrick