第30次：2015-04-02星期四：1Z0-52第8章

botang

1. select count(  distinct  sp.privilege )
   
2.   from dba_sys_privs sp ;
   
3.   
   
4.   select  distinct  sp.privilege   from dba_sys_privs sp order by 1 ;
   
5.   
   
6.   select  * from dba_users  where username='OE';
   
7.   
   
8.   select  * from user$ where name='HR';
   
9.   
   
10.   grant sysdba to hr;
    
11.   
    
12.   revoke   sysdba from hr;
    
13.   
    
14.     grant sysoper to hr;
    
15.   
    
16.   revoke   sysoper  from hr;
    
17.   
    
18.   alter user oe password expire account lock;
    
19.   
    
20.   
    
21.     select  * from dba_users  where username='U1';
    
22.    
    
23.     select  * from dba_sys_privs sp where sp.grantee='U1';
    
24.    
    
25.     select  * from dba_tab_privs  tp where tp.grantee='U1';
    
26.    
    
27.     select * from  dba_role_privs rp where rp.grantee='U1';
    
28.    
    
29.     ---
    
30.    
    
31.     select * from dba_segments s where s.owner='U1' and s.segment_name='T1';
    
32.    
    
33.     select  * from dba_extents e where e.owner='U1' and e.segment_name='T1';
    
34.    
    
35.     select  * from dba_ts_quotas;
    
36.    
    
37.     select  * from dba_Tables t where t.owner='HR' and t.table_name='T777';

复制代码