????Oracle????????????????????????????????????System Privilege????????????Object Privilege??????????Role Privilege???????????????????????е??Щ???????????????????????????????????????????????????????????????????????????????????????????????????????????????????????????С?
???????????????????????????????Oracle??????????????????????????÷??????????????潨???????????????????в??????????????????????Щ????????????????????п?????????Web?????????Oracle???????????????????????????????Web?????????????????Schema??????????????????????ò??????????
???????????????????????Role???????????????Default Role?????????????????ó????????????????????????????????
????1??????????
????Oracle??????????????汾?ж????????????????????????Oracle 11g??????汾???11.2.0.4??
????SQL> select * from v$version;
????BANNER
????--------------------------------------------------------------------------------
????Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
????PL/SQL Release 11.2.0.4.0 - Production
????CORE      11.2.0.4.0     Production
????TNS for Linux: Version 11.2.0.4.0 - Production
????NLSRTL Version 11.2.0.4.0 – Production
?????????????μ??????
????SQL> create user test identified by test;
????User created
????2??Default Role????
?????????????????????????????????????????????????????????????????????????????????????Group???????????????????????????Role Privilege?????????????????????????????ù??????????????????????????衣??????????????????裬????????????á???????????????????????????????
????????????????????????????test???????н?????趯????
????SQL> grant connect?? resource to test;
????Grant succeeded
????SQL> grant sicspccgrole to test;
????Grant succeeded
????SQL> grant sicspctbcgrole to test;
????Grant succeeded
????SQL> grant sicspctrrole to test;
????Grant succeeded
??????????db_role_privs??????????????????????
????SQL> select * from dba_role_privs where GRANTEE='TEST';
????GRANTEE                        GRANTED_ROLE                   ADMIN_OPTION DEFAULT_ROLE
????------------------------------ ------------------------------ ------------ ------------
????TEST                           RESOURCE                       NO           YES
????TEST                           SICSPCCGROLE                   NO           YES
????TEST                           SICSPCTBTRROLE                 NO           YES
????TEST                           CONNECT                        NO           YES
????TEST                           SICSPCTBCGROLE                 NO           YES
????TEST                           SICSPCTRROLE                   NO           YES
????6 rows selected
?????????default_role?У????test??????????????????default_role????????????????????????????????????????default role??