第43次：2016-01-28星期四

botang · 发表于 2016-1-29 09:41:20

2016-01-28a.sql：

select * from dba_objects o where
o.object_name like 'VERIFY_FUNCTION%';
select * from dba_profiles p where p.profile='PROFILE1'
and p.resource_type='PASSWORD';
alter profile profile1 limit PASSWORD_VERIFY_FUNCTION verify_function;
alter user hr profile default;
----
select count(*) from dba_audit_trail;
select * from dba_audit_trail a order by a.timestamp desc;
---
select count(*) from dba_audit_trail;
select * from dba_audit_trail a order by a.timestamp desc;
select * from dba_views v where v.view_name='DBA_AUDIT_TRAIL';
select count(*) from aud$;
select * from aud$;
select * from dba_tables t where t.table_name='AUD
;
create tablespace tbsaudit datafile size 20M autoextend on;
alter table aud$ move tablespace tbsaudit;
-----
select * from dba_audit_trail a order by a.timestamp desc;
---
select * from dba_obj_audit_opts;
AUDIT ALL on hr.employees;
select * from dba_obj_audit_opts;
audit select on hr.employees by access whenever successful;
noAUDIT ALL on hr.employees;
----
select * from dba_obj_audit_opts;
---
select * from dba_audit_trail a where a.username not in ('DBSNMP','SYSMAN')
order by a.timestamp desc;
noaudit select on hr.employees;
audit select on hr.employees whenever not successful;
---
select * from v$xml_audit_trail where db_user not in ('DBSNMP','SYSMAN','sys')
order by 6 desc ;
---
audit update on hr.employees by access whenever successful;
---
select * from dba_common_audit_trail where db_user not in ('DBSNMP','SYSMAN','sys')
order by 6 desc ;
---
select * from dba_priv_audit_opts;
select * from dba_stmt_audit_opts
minus
select * from dba_priv_audit_opts;

复制代码