第44和45次：2015-08-22星期六上下午

botang · 发表于 2015-8-22 23:06:07

本帖最后由 botang 于 2015-8-22 23:15 编辑

上完1Z0-052第8章       （52-37）
上完1Z0-052第9章       （52-38）
上完1Z0-052第10章       （52-39）

2015-08-22a.sql：

select distinct sp.privilege from
dba_sys_privs sp ;
select *
from dba_sys_privs sp where sp.grantee='U1';
select *
from dba_tab_privs tp where tp.grantee='U1';
select *
from dba_col_privs cp where cp.grantee='U1';
select *
from dba_role_privs rp where rp.grantee='U1';
revoke select on hr.employees from u1;
select *
from dba_sys_privs sp where sp.grantee='U2';
select *
from dba_tab_privs tp where tp.grantee='U2';
select *
from dba_col_privs cp where cp.grantee='U2';
select *
from dba_role_privs rp where rp.grantee='U2';
grant select any table to u1 with admin option;
revoke select any table from u1;
revoke select any table from u2;
grant select on hr.employees to u1 with grant option;
revoke select on hr.employees from u1;
select * from dba_roles order by 1 ;
create role r1 ;
select * from role_role_privs rrp where rrp.role='R1';
select * from role_tab_privs rtp where rtp.role='R1';
select * from role_sys_privs rsp where rsp.role='R1';
grant select on hr.employees to r1;
grant r1 to u1 with admin option;
revoke r1 from u1;
revoke select on hr.employees from r1;
revoke r1 from u2;
drop role r1;
create role r1 identified by oracle_4U ;
grant select on hr.employees to r1;
grant r1 to u1 ;
alter role r1 identified by redhat_4U;
alter system kill session '201,35' immediate;
select * from v$session where username='U1';
select *
from dba_role_privs rp where rp.grantee='U1';
create role r2 ;
grant create any index to r2;
grant r2 to u1;
alter user u1 default role none;
alter user u1 default role connect,r1;
grant r2 to r1;
----
select *
from dba_sys_privs sp where sp.grantee='U3';
select *
from dba_tab_privs tp where tp.grantee='U3';
select *
from dba_col_privs cp where cp.grantee='U3';
select *
from dba_role_privs rp where rp.grantee='U3';
create role r3 ;
grant select on hr.employees to r3;
grant r3 to u3;
grant create procedure to u3;
revoke r3 from u3;
grant select on hr.employees to u3;

复制代码

2015-08-22b.sql：

CREATE PROFILE "PROFILE1" LIMIT
FAILED_LOGIN_ATTEMPTS 1;
select * from dba_profiles p where p.profile='PROFILE1' and p.resource_type='PASSWORD';
select * from dba_users where username='HR';
alter user hr profile profile1;
alter user hr account unlock;
ALTER PROFILE "PROFILE1" LIMIT PASSWORD_LOCK_TIME 0.000694444;
ALTER PROFILE "PROFILE1" LIMIT PASSWORD_REUSE_MAX 1
PASSWORD_REUSE_TIME 0.000694444;
ALTER PROFILE "PROFILE1" LIMIT PASSWORD_verify_function verify_function_11g;

复制代码

2015-08-22c.sql：

select * from dba_tablespaces;
create temporary tablespace temp2 tempfile '/u01/app/oracle/oradata/orcl/temp2.dbf'
size 15G;
select * from database_properties;
alter database default temporary tablespace temp2;
create undo tablespace undotbs1 datafile size 100M autoextend on maxsize 20G;
drop tablespace undotbs1;
select * from dba_rollback_segs;
select * from v$transaction ;
select * from v$session where taddr='00000001EAEBE200';
alter system kill session '8,3111' immediate;
select * from dba_tablespaces;
alter tablespace undotbs1 retention guarantee;
select * from dict where table_name like '%UNDO%' or table_name like '%ROLLBACK%';
select * from DBA_HIST_UNDOSTAT;
select * from v$undostat;

复制代码