oracle创建用户与数据库
--1、创建表空间,文件位置请按照安装目录去修改 Create tablespace FLOW_data datafile 'D:ORADATAORCLFLOW_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;