Bo's Oracle Station

查看: 2248|回复: 0

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

[复制链接]

1005

主题

1469

帖子

1万

积分

管理员

Rank: 9Rank: 9Rank: 9

积分
12012
发表于 2016-1-22 09:35:00 | 显示全部楼层 |阅读模式
第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';




回复

使用道具 举报

您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

QQ|手机版|Bo's Oracle Station   

GMT+8, 2024-3-28 22:49 , Processed in 0.035423 second(s), 24 queries .

快速回复 返回顶部 返回列表