夏日的草原,早晨空气格外清新,我缠着父亲在草原上漫步。幽幽的草香迎面拂来,红艳艳。朝阳正从地平线上冉冉升起,为辽阔的草原镀上一层金色。草叶上的露珠,像镶在翡翠上的珍珠,闪着五颜六色的光华。我看到草丛中夹着许多粉红色、白色、黄色或是蓝色的不知名的花,把草原装扮得十分美丽。
oracle创建表空间,授权,创建用户,导入dmp文件,具体详解如下所示:
1.创建表空间
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-- 创建用户
2.创建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 创建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下的表授权给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数据中,给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文件,希望对大家有所帮助,如果大家有任何疑问请给我留言,小编会及时回复大家的。在此也非常感谢大家对网站的支持!
以上就是oracle创建表空间、授权、创建用户、导入dmp文件。善欲人知不是真善,恶恐人知便是大恶。更多关于oracle创建表空间、授权、创建用户、导入dmp文件请关注haodaima.com其它相关文章!