I have a requirement to generate an audit report based on Employee and Department like the below
1) Can select employee Id(emp table) or manager name(manager table)
2) Department(dept table)
Report should have the following when they access the tables.generate the audit information
manager name (manger table)
employee Id (emp table)
like which manager tried to access which employee
can you please advise.