Oracle EBS已经存在表fnd_logins,可以通过设置配置文件对Oracle EBS用户登录行为进行记录,但默认没有打开。
默认情况下该表已经有大量的记录了,类型为Concurrent,猜测为用户提交并发请求的日志记录,Concurrent实际并没有什么作用:
建议值:用户
配置文件值含义
1)NONE– no audit enabled (Default value)
2)USER– audit user login to system,the logon time and the logoff time.
3)RESPONSIBILITY– audit all the above + which responsibilities the user chose and how long he stayed in each responsibility.
RESPONSIBILITY,记录用户登录+用户什么时候进入某一责任,在每个责任停留时间
4)FORM– audit all the above + which forms the user used and how long he stayed in each form.
表单,记录用户登录+责任+用户什么时候打开哪个Forms界面
不同的日志,记录在不同的表里面:
– populates the FND_LOGINS table only.
– populates FND_LOGINS and FND_LOGIN_RESPONSIBILITIES tables.
– populates FND_LOGINS,FND_LOGIN_RESPONSIBILITIES and FND_LOGIN_RESP_FORMS tables.
FND_LOGINS– holds information about users login to system,when and how long.
This table holds one row for each login.
FND_LOGIN_RESPONSIBILITIES– holds information about changes of responsibilities,when and how long being at each responsibility.
For each change this table holds one row with values that identify the user's login session,the user's current responsibility,and when the user is in the responsibility
FND_LOGIN_RESP_FORMS– holds information about using forms,sans-serif; line-height: 19.2px;">This table holds one row for each form used in the same session with values that identify the user's login session,current responsibility,when and how long using each form.
注:此时可以通过 系统管理员-安全性-用户-监控,监控当前登录系统的用户