oracle 创建用户

create tablespace jk datafile 'D:\orcl\tablespace\jk.dbf' size 900m;
create user jk identified by jk default tablespace jk;

grant connect,resource to jk;

grant dba to jk;

或者
GRANT
　　CREATE SESSION, CREATE ANY TABLE, CREATE ANY VIEW ,CREATE ANY INDEX, CREATE ANY PROCEDURE,
　　ALTER ANY TABLE, ALTER ANY PROCEDURE,
　　DROP ANY TABLE, DROP ANY VIEW, DROP ANY INDEX, DROP ANY PROCEDURE,
　　SELECT ANY TABLE, INSERT ANY TABLE, UPDATE ANY TABLE, DELETE ANY TABLE
　　TO jk;



alter user sys identified by 密码



---创建表空间

create tablespace lhy logging datafile '/opt/oracle/oradata/lhy.ora' size 100m autoextend on next 200m maxsize unlimited extent Management local segment space management auto;

----创建用户

Create user lhy profile default Identified by lhy default tablespace lhy;

----附权限

Grant connect to lhy with admin option;

Grant dba to lhy with admin option;

Grant create any table to lhy with admin option;