本文共 1856 字，大约阅读时间需要 6 分钟。

Oracle???????????

?Oracle???????????????????DBA??????????????????Oracle??????????????????????????

1.1 ?????

???????????????????????????????????????????

-- ?????jofficeCREATE TABLESPACE joffice DATAFILE 'D:\oracle\data\joffice.dbf' LOGGING DATAFILE SIZE 50M AUTOEXTEND ON NEXT 10M MAXSIZE 400M EXTENT MANAGEMENT LOCAL;

???????????????????

CREATE USER joffice IDENTIFIED BY joffice DEFAULT TABLESPACE joffice;

1.2 ????

???????????????????????????????????????????

-- ????jofficeCREATE USER joffice IDENTIFIED BY joffice;-- ????joffice??????ALTER USER joffice DEFAULT TABLESPACE joffice;

???????????????

ALTER USER joffice IDENTIFIED BY new_password;

???????????????????????????????????????

-- ????jofficeDROP USER joffice CASCADE;

1.3 ????

?Oracle?????Role??????????????????????????????DBA????????????????

-- ????CREATE ROLE testRole;-- ?testRole??SELECT??GRANT SELECT ON testClass TO testRole;

?????????????

ALTER ROLE testRole SET DEFAULT_TABLESPACE joffice;

1.4 ????

????????????????????????????

-- ???joffice?????????GRANT CONNECT, RESOURCE TO joffice;-- ???test?????????GRANT CONNECT, RESOURCE TO test;

?????????????

-- ???joffice?????????REVOKE CONNECT, RESOURCE FROM joffice;

1.5 ???????

???????????????????????????????????????????????????

-- ????testRoleCREATE ROLE testRole;-- ?testRole??SELECT??GRANT SELECT ON testClass TO testRole;

-- ????testRoleDROP ROLE testRole;

1.6 ???????

?Oracle????????SYS?DBA?OPERATOR?????DBA??????????

-- ???joffice??DBA??GRANT DBA TO joffice;

1.7 ??????

???????????????????????????????????????

-- ???????SHOW USER_PRIVILEGES;-- ???????????hipSELECT * FROM DBA_ROLE_PRIVS WHERE role_name = 'testRole';

1.8 ????????

???????????????????

1.9 ??

Oracle??????????????????????????????????????????????????????????????????????????????