第45次：2016-01-11星期一

botang · 发表于 2016-1-12 09:30:26

本帖最后由 botang 于 2016-1-12 09:40 编辑

第45次：2016-01-11星期一

select * from dba_tablespaces;
create tablespace tbsaudit datafile size 20M autoextend on;
select * from dba_views where view_name='DBA_AUDIT_TRAIL';
select * from dba_tables t where t.table_name='AUD
;
alter table aud$ move tablespace tbsaudit;
truncate table aud$;
select * from aud$;
-------------------------
select * from dict where table_name like '%OPT%';
select * from DBA_OBJ_AUDIT_OPTS;
select * from DBA_PRIV_AUDIT_OPTS p order by p.privilege;
select * from DBA_STMT_AUDIT_OPTS a order by a.audit_option;
select * from DBA_STMT_AUDIT_OPTS
minus
select * from DBA_PRIV_AUDIT_OPTS;
----
audit select on hr.employees ;
select * from dba_audit_trail where username='HR' order by timestamp desc;
----
noaudit select on hr.employees ;
audit select on hr.employees by access;
-----
audit update on hr.employees whenever successful;
select * from dba_audit_trail where username ='SYS' order by timestamp desc;
---
select * from dba_tablespaces;
create tablespace tbsaudit datafile size 20M autoextend on;
select * from dba_views where view_name='DBA_AUDIT_TRAIL';
select * from dba_tables t where t.table_name='AUD
;
alter table aud$ move tablespace tbsaudit;
truncate table aud$;
select * from aud$;
-------------------------
select * from dict where table_name like '%OPT%';
select * from DBA_OBJ_AUDIT_OPTS;
select * from DBA_PRIV_AUDIT_OPTS p order by p.privilege;
select * from DBA_STMT_AUDIT_OPTS a order by a.audit_option;
select * from DBA_STMT_AUDIT_OPTS
minus
select * from DBA_PRIV_AUDIT_OPTS order by 3 desc ;
----
audit select on hr.employees ;
select * from dba_audit_trail where username='HR' order by timestamp desc;
----
noaudit select on hr.employees ;
audit select on hr.employees by access;
-----
audit update on hr.employees whenever successful;
select * from dba_audit_trail order by timestamp desc;
audit table by sh by session;
----
grant select any table to sh;
----
select * from v$xml_audit_trail ;
---
audit select any table by sh by session ;
---
select * from dba_audit_trail order by timestamp desc;
---
noaudit drop any table by sh;
audit drop any table by sh by access whenever successful;
----
---XML
grant drop any table to sh;
-----
select * from dba_common_audit_trail order by 6 desc ;
---
create table tvalue ( a varchar2(1000)) tablespace tbsaudit ;
---
create or replace trigger trgvalue
after update of salary on hr.employees
referencing new as new old as old
for each row
begin
if :old.salary != :new.salary then
insert into tvalue
values (sys_context('userenv','os_user')||sysdate||' modified '||:new.salary|| :old.salary||'.'||
sys_context('userenv','current_user')|| sys_context('userenv','session_user')
);
end if;
end;
select * from dba_objects o where o.object_name='TRGVALUE';
select * from user_errors ;
select * from tvalue;

复制代码