oracle 创建用户使用的语句

ORACLE数据库：

//创建临时表空间

create temporary tablespace apportal_TEMP

tempfile 'E:\Oracle11g\oradata\orcl11g\apportal_TEMP.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

//创建表空间

create tablespace apportal_DS

logging

datafile 'E:\Oracle11g\oradata\orcl11g\apportal_DS.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

//创建用户

create user apportal identified by apportal

default tablespace apportal_DS

temporary tablespace apportal_TEMP;

//给用户赋权限

grant connect,resource to apportal;

//当前用户的默认表空间

select username,default_tablespace from user_users;

//修改用户密码

alter user 用户名 identified by 修改之后的密码