oracle数据库创建用户

 --4.1 创建表空间
CREATE TABLESPACE mdm_data DATAFILE 'D:\soft\Oracle\oracl\oradata\mdm_data01.dbf' SIZE 300M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 256K ;
CREATE TABLESPACE iuap_index DATAFILE 'D:\soft\Oracle\oracl\oradata\iuap_index01.dbf' SIZE 50M AUTOEXTEND ON NEXT 50M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 128K ;
--4.2 创建用户
CREATE USER mdmiuap IDENTIFIED BY mdmiuap DEFAULT TABLESPACE mdm_data TEMPORARY TABLESPACE temp;
--4.3 根据自己的权限设计授权
GRANT CONNECT,DBA,RESOURCE,select any dictionary TO mdmiuap;