创建用户~表空间~分配权限~导入dmp

--创建用户
create user fdjtest identified by zzg123;
--修改用户的密码
alter user fdjtest identified by fdjtest;
--默认情况下用户创建好后系统会默认给该用户分配一个表空间（users）
--查看用户所在的表空间
select username,default_tablespace from dba_users;
--创建一个表空间
create tablespace fdj_zzg datafile 'F:\app\Administrator\oradata\orcl\fdj_data.dbf' size 3000M;   
将表空间分配给用户
alter user fdjtest default tablespace fdj_zzg;  
--用户分配权限 
grant create session,create table,create view,create sequence,
unlimited tablespace to fdjtest; 

--删除表空间
drop tablespace fdj_zzg including contents and datafiles;

exp jachtwms/jachtwms@orcl file=F:\jachtwms20150129.dmp
imp userid=fdjtest/fdjtest@orcl fromuser=jachtwms  file='F:\jachtwms20150129.dmp'

 

-----------创建查询用户
drop user FDJTEST_VIEW cascade; 

create user FDJTEST_VIEW identified by zzg123;
alter user fdjtest_view identified by fdjtest_view;

--alter user fdjtest_view default tablespace fdj_zzg;
--grant create session,create table,create view,create sequence,
--unlimited tablespace to fdjtest; 

grant create session to fdjtest_view;

wei_zhi_middle用户登陆....
grant select on t_dms_01 to fdjtest_view

fdjtest_view用户登录....
select * from wei_zhi_middle.t_dms_01