创建表空间和用户并授权，更改用户

--group1
create TABLEspace group1 datafile 'F:\app\lianqiao\oradata\ts\group1.dbf' size 10m;--创建表空间
create user group1 identified by 000000 default tablespace group1;--创建用户
grant resource,connect,dba to group1;--授权

以group用户登录时修改密码：

alter user group4 identified by 123;

-- USER SQL
ALTER USER HR  IDENTIFIED BY . 
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
ACCOUNT UNLOCK ;

-- ROLES
ALTER USER HR DEFAULT ROLE "RESOURCE";

-- SYSTEM PRIVILEGES

-- QUOTAS