第41次：2016-01-21星期四

botang

第41次：2016-01-21星期四：

select  * from dba_users   where  username='U2';

select * from dba_views v where v.view_name='DBA_USERS';

select * from user$;

drop user u1 cascade;

create user u1 identified by oracle_4U ;

grant create session to u2 identified by oracle_4U;
grant connect to u1 identified by oracle_5U;
----
select  distinct  s.privilege  from dba_sys_privs s   order by 1  ;

select  *  from dba_sys_privs s  where s.grantee='U1';

select * from dba_tab_privs;

select  * from dba_col_privs;

select  * from dba_role_privs  r where r.grantee='U2';

select  * from dba_role_privs r where r.grantee='HR';

select * from  role_sys_privs   r where r.role='RESOURCE';

select  * from role_tab_privs r  where r.role='RESOURCE'  ;

select  * from role_role_privs   r where r.role='RESOURCE'  ;

grant create table to u1;

----

select * from dba_segments s where s.owner='U1' and s.segment_name='T05208_U1';

---

select  * from dba_ts_quotas;

alter user u1 quota 1M on users;
---

grant resource to u2 ;
------------------
-------------------
create user ops$oracle identified  externally;

create user ...   identified using pack....

select  *  from dba_sys_privs s  where s.grantee='OPS$ORACLE';
select  * from dba_role_privs  r where r.grantee='OPS$ORACLE';

grant connect to ops$oracle;

----
grant sysdba to u3 ;

----
select * from  role_tab_privs   r where r.role='SELECT_CATALOG_ROLE';