????3?????????
--???
GRANT
CONNECT??
RESOURCE??
--DBA??
--unlimited tablespace??
CREATE  SESSION??
CREATE ANY SEQUENCE??
CREATE ANY TABLE??
CREATE ANY VIEW ??
CREATE ANY INDEX??
CREATE ANY PROCEDURE??
CREATE ANY DIRECTORY??
ALTER  SESSION??
ALTER ANY SEQUENCE??
ALTER ANY TABLE??
--ALTER ANY VIEW ??        --??????????
ALTER ANY INDEX??
ALTER ANY PROCEDURE??
--ALTER ANY DIRECTORY??    --?????????
--DROP  SESSION??       --???????Session
DROP ANY SEQUENCE??
DROP ANY TABLE??
DROP ANY VIEW ??
DROP ANY INDEX??
DROP ANY PROCEDURE??
DROP ANY DIRECTORY??
SELECT ANY TABLE??
SELECT ANY DICTIONARY??
INSERT ANY TABLE??
UPDATE ANY TABLE??
DELETE ANY TABLE??
DEBUG ANY PROCEDURE??
DEBUG CONNECT SESSION??
exp_full_database??
imp_full_database
TO xcj01;
??????????????????
???????μ????У??????????DBA???????в????????????????п????????????????
????1????????????Щ???
????select * from dba_role_privs a where a.grantee='XCJ01';
????--??
????select * from dba_sys_privs a where a.grantee='XCJ01';
????2????????????Щ???
????select ROLE?? PRIVILEGE from role_sys_privs where role='RESOURCE';   --RESOURCE??CONNECT??DBA
????--??
????select grantee??privilege from dba_sys_privs where grantee='RESOURCE';
????3????????????
????revoke resource from XCJ01;
????4????????????
????revoke unlimited tablespace from XCJ01;
????5???????????????????????Oracle??汾???
????select * from v$version where rownum 1;
?????壺???
??????Щ??Oracle??????????????????????????????????????????????????????DBA???????????????????д???????????