oracle創(chuàng)建表空間，授權(quán)，創(chuàng)建用戶，導(dǎo)入dmp文件，具體詳解如下所示：
1.創(chuàng)建表空間
Create tablespace bpm datafile 'D:\ORACLE11\ORADATA\ORCL\BPM.DBF' size 400M autoextend on Create tablespace lyoa datafile 'D:\ORACLE11\ORADATA\ORCL\LYOA.DBF' size 400M autoextend on Create tablespace kdb datafile 'D:\ORACLE11\ORADATA\ORCL\KDB.DBF' size 400M autoextend on
2-- 創(chuàng)建用戶
2.創(chuàng)建LYOA用戶
create user LYOA identified by LYOA default tablespace LYOA temporary tablespace TEMP profile DEFAULT; -- Grant/Revoke role privileges grant connect to LYOA; grant resource to LYOA; -- Grant/Revoke system privileges grant create database link to LYOA; grant create public database link to LYOA; grant create view to LYOA;
3 創(chuàng)建KDB用戶
create user KDB identified by KDB default tablespace KDB temporary tablespace TEMP profile DEFAULT; -- Grant/Revoke role privileges grant connect to KDB; grant resource to KDB;
4 把LYOA下的表授權(quán)給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 privileges grant create view to KDB; grant unlimited tablespace to KDB; -- Create the user create user BPM identified by BPM default tablespace BPM temporary tablespace TEMP profile DEFAULT; -- Grant/Revoke role privileges grant connect to BPM; grant resource to BPM; -- Grant/Revoke system privileges grant 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數(shù)據(jù)中，給scott用戶connect resource sysdb的權(quán)限 創(chuàng)建三個(gè)用戶
登錄 SYS/ AS SYSDBA
2.登錄每個(gè)用戶導(dǎo)入對(duì)應(yīng)用戶的表
導(dǎo)入用戶的表 給與lyoa用戶dba的權(quán)限 grant dba to lyoa
imp lyoa/lyoa@localhost/orcl file=F:\lyoa.dmp full=y
3.用戶沒(méi)有授權(quán)需要登錄 SYS/ AS SYSDBA 之后 sysdba為密碼進(jìn)行授權(quán)
以上所述是小編給大家介紹的oracle創(chuàng)建表空間、授權(quán)、創(chuàng)建用戶、導(dǎo)入dmp文件，希望對(duì)大家有所幫助，如果大家有任何疑問(wèn)請(qǐng)給我留言，小編會(huì)及時(shí)回復(fù)大家的。在此也非常感謝大家對(duì)腳本之家網(wǎng)站的支持！
標(biāo)簽：紹興 寧波 海東 遼源 百色 昭通 中衛(wèi) 自貢
巨人網(wǎng)絡(luò)通訊聲明：本文標(biāo)題《oracle創(chuàng)建表空間、授權(quán)、創(chuàng)建用戶、導(dǎo)入dmp文件》，本文關(guān)鍵詞 oracle,創(chuàng)建,表,空間,授權(quán),；如發(fā)現(xiàn)本文內(nèi)容存在版權(quán)問(wèn)題，煩請(qǐng)?zhí)峁┫嚓P(guān)信息告之我們，我們將及時(shí)溝通與處理。本站內(nèi)容系統(tǒng)采集于網(wǎng)絡(luò)，涉及言論、版權(quán)與本站無(wú)關(guān)。
