Oracle 视图 USER_AUDIT_SESSION 官方解释，作用，如何使用详细说明
本站中文解释
Oracle 视图 USER_AUDIT_SESSION 是审计用户会话的档案信息，用于查看受审计数据库会话已连接的用户、审计类型等信息。其包含下列列：
• Session_Id： 会话ID
• Audit_Type： 审计类型
• Instance_Number： 示例号码
• Schema_Id： 架构ID
• Schema_Name： 架构名称
• Os_User： 操作系统用户
• Login_Id： 登录ID
• Privilege_Id： 权限ID
• Session_Info： 会话信息
• Event_Time： 事件事时
使用 USER_AUDIT_SESSION 视图在 Oracle 数据库中, 可以以下SQL 语句查看审计会话的详细信息：
SELECT * FROM USER_AUDIT_SESSION;
官方英文解释
USER_AUDIT_SESSION displays the audit trail records concerning connections and disconnections of the current user. Its columns are the same as those in DBA_AUDIT_SESSION.
Note:
This view is relevant when using traditional auditing. Traditional auditing is deprecated in Oracle Database 21c. Oracle recommends that you instead use unified auditing, which enables selective and more effective auditing inside Oracle Database.
-
“DBA_AUDIT_SESSION”
-
See Oracle Database Security
Guide for more information about unified auditing. -
See Oracle Database Upgrade
Guide for more information about migrating to unified auditing.
This view is populated only in an Oracle Database where unified auditing is not enabled. When unified auditing is enabled in Oracle Database, the audit records are populated in the new audit trail and can be viewed from UNIFIED_AUDIT_TRAIL.
