Oracle数据库命令速查手册-manager role

1.create roles 
sql> create role sales_clerk; 
sql> create role hr_clerk identified by bonus; 
sql> create role hr_manager identified externally; 
2.modify role 
sql> alter role sales_clerk identified by commission; 
sql> alter role hr_clerk identified externally; 
sql>alter role hr_manager not identified;
3.assigning roles 
sql> grant sales_clerk to scott; 
sql> grant hr_clerk to hr_manager; 
sql> grant hr_manager to scott with admin option; 
4.establish default role 
sql> alter user scott default role hr_clerk,sales_clerk; 
sql> alter user scott default role all; 
sql> alter user scott default role all except hr_clerk; 
sql> alter user scott default role none; 
5.enable and disable roles 
sql> set role hr_clerk; 
sql> set role sales_clerk identified by commission; 
sql> set role all except sales_clerk; 
sql> set role none; 
6.remove role from user 
sql> revoke sales_clerk from scott; 
sql> revoke hr_manager from public; 
7.remove role 
sql> drop role hr_manager; 
8.display role information 
view: =>dba_roles,dba_role_privs,role_role_privs,dba_sys_privs,role_sys_privs,role_tab_privs,session_roles