oracle創建表空間，授權，創建用戶，導入dmp文件，具體詳解如下所示：
1.創建表空間
Create tablespace bpm datafile 'D:/ORACLE11/ORADATA/ORCL/BPM.DBF' size 400M autoextend onCreate tablespace lyoa datafile 'D:/ORACLE11/ORADATA/ORCL/LYOA.DBF' size 400M autoextend onCreate tablespace kdb datafile 'D:/ORACLE11/ORADATA/ORCL/KDB.DBF' size 400M autoextend on
2-- 創建用戶
2.創建LYOA用戶
create user LYOAidentified by LYOAdefault tablespace LYOAtemporary tablespace TEMPprofile DEFAULT;-- Grant/Revoke role privilegesgrant connect to LYOA;grant resource to LYOA;-- Grant/Revoke system privilegesgrant create database link to LYOA;grant create public database link to LYOA;grant create view to LYOA;
3 創建KDB用戶
create user KDBidentified by KDBdefault tablespace KDBtemporary tablespace TEMPprofile DEFAULT;-- Grant/Revoke role privilegesgrant connect to KDB;grant resource to KDB;
4 把LYOA下的表授權給KDB用戶
grant all on lyoa.oa_public_address_book to KDB;grant all on lyoa.oa_public_address_book_group to KDB;grant all on bpm.bpm_orgdeptlist to KDB;grant all on bpm.bpm_orguserdeptmap to KDB;grant all on bpm.bpm_orguserlist to KDB;-- Grant/Revoke system privilegesgrant create view to KDB;grant unlimited tablespace to KDB;-- Create the usercreate user BPMidentified by BPMdefault tablespace BPMtemporary tablespace TEMPprofile DEFAULT;-- Grant/Revoke role privilegesgrant connect to BPM;grant resource to BPM;-- Grant/Revoke system privilegesgrant create database link to BPM;grant create public database link to BPM;grant create view to BPM;grant drop public database link to BPM;grant unlimited tablespace to BPM;grant all on lyoa.ly_im_news_2 to bpm;grant all on lyoa.oa_system_message to bpm;
1.在orac數據中，給scott用戶connect resource sysdb的權限 創建三個用戶
登錄 SYS/ AS SYSDBA
2.登錄每個用戶導入對應用戶的表
導入用戶的表 給與lyoa用戶dba的權限 grant dba to lyoa
imp lyoa/lyoa@localhost/orcl file=F:/lyoa.dmp full=y
3.用戶沒有授權需要登錄 SYS/ AS SYSDBA 之后 sysdba為密碼進行授權
以上所述是小編給大家介紹的oracle創建表空間、授權、創建用戶、導入dmp文件，希望對大家有所幫助，如果大家有任何疑問請給我留言，小編會及時回復大家的。在此也非常感謝大家對武林網網站的支持！
新聞熱點
疑難解答
