i have implemented particular employee can do ddl statement in schema.. based on their machine name using userenv and ora_sysevent. but ora_sysevent not shows anything for DML operation.. how can i find that .. example users execute insert statement , i need insert .. so i can restrict in existing trigger itself.. also i need to differentiate session connections.. it's connected from users application or from application..
i finalized v$session - program can get JDBC thin client.. so i can allo only dml operation for jdbc thin client..
my requirement is only particular users can do ddl,dml operation from backend.. others can do dml from front end application..
i need to find event for insert,update,delete event name in trigger....
Please help for this...