CNC, DB and Operating System - JDE1 (MOSC)

MOSC Banner

How can I use a SQL query to determine what user was removed from a role and who made the change?

edited Mar 8, 2024 8:31PM in CNC, DB and Operating System - JDE1 (MOSC) 5 commentsAnswered ✓

JDE Enterprise One Version 9.2

windows environment

I am trying to create a query that would tell me who was removed from roles and who made the changes in JDE.

If an out of the box report exists for this (I could not find one) then that's cool but i would prefer to use a SQL query and export the data to excel.

If not can someone point to the needed tables to look through? I have been through SY920.F9312 but I am not sure if that table is right as I cannot get a listing of what each of the event codes means. I would also need to know which role was removed. This would be a query of the entire user base.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

E1 CNC/DBOS Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center