问个问题，oracle中我想知道昨天是哪个用户哪个IP对表数据修改了，这个能查到吗，在哪查，归档日志？

0
2015-11-10 添加评论
分享

没有找到相关结果

    已邀请:
    1

    老头子 - 专注是唯一的捷径 2015-11-10 回答

    开审计功能
     
    默认情况下审计是没有开启的，审计记录包含有审计的操作、用户执行的操作、操作的日期和时间等信息。
     

           Databaseauditing is the monitoring and recording of selected user database actions. You can use standard auditing to audit SQL statements,privileges, schemas, objects, and network and multitier activity.Alternatively, you can use fine-grained auditingto monitor specific database activities, such as actions on a database table ortimes that activities occur. For example, you can audit a table accessed after9:00 p.m.

     

    Reasons for using auditing include:

           （1）Enabling future accountability for current actions

           （2）Deterring users (or others, such as intruders) from inappropriateactions based on their accountability

           （3）Investigating, monitoring, and recording suspicious activity

           （4）Addressing auditing requirements for compliance

    2015-11-10 1
    分享
    为什么被折叠? 0 个回复被折叠

    要回复问题请先登录或注册