oracle创建用户与数据库

oracle创建用户与数据库

--1、创建表空间，文件位置请按照安装目录去修改
Create tablespace FLOW_data
datafile 'D:\ORADATA\ORCL\FLOW_data.DBF'
size 100M AutoExtend On Next 100M Maxsize Unlimited
extent management local segment space management auto;

--2、创建用户
CREATE USER FLOW  PROFILE DEFAULT IDENTIFIED BY FLOW   
DEFAULT TABLESPACE FLOW_data  TEMPORARY TABLESPACE TEMP  ACCOUNT UNLOCK 

--3、给用户添加角色和添加权限
GRANT DBA, RESOURCE, CONNECT TO FLOW  ;
GRANT  CREATE ANY TABLE,CREATE ANY VIEW ,CREATE ANY SEQUENCE,
SELECT ANY DICTIONARY,unlimited tablespace  TO FLOW;

--4、解决以dba能登陆，以普通用户不能登录
　 alter user flow identified by flow; 
   ALTER USER flow ACCOUNT UNLOCK;