oracle创建表空间授权用户

一、表空间授权用户

create tablespace  bytpms
logging 
datafile 'd:\bytpmsdata\orcl\bytpms.dbf'
size 1024m 
autoextend on 
next 50m maxsize 1048m 
extent management local;

-- 创建用户
create user bytpms
  identified by "bytpms"
  default tablespace bytpms
  temporary tablespace TEMP
  profile DEFAULT;
--用户授权
grant connect to bytpms with admin option;
grant resource to bytpms with admin option;
grant imp_full_database to bytpms with admin option;
grant exp_full_database to bytpms with admin option;