Oracle创建用户、角色、授权、建表
?????????????????????????? ??????????????????????????????????????? ??????????????????????????
发布日期:2025-04-30 00:58:50
浏览次数:15
分类:精选文章
本文共 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??????????????????????????????????????????????????????????????????????????????
发表评论
最新留言
初次前来,多多关照!
[***.217.46.12]2026年06月12日 10时40分34秒
关于作者
喝酒易醉,品茶养心,人生如梦,品茶悟道,何以解忧?唯有杜康!
-- 愿君每日到此一游!