oracle pl/sql 中创建用户

模式：

create user 用户名

default tablespace 表空间名;

举例：

-- Create the user

create user ACCOUNT

identified by ""

default tablespace ACCOUNTTS

temporary tablespace TEMP

profile DEFAULT;

-- Grant/Revoke role privileges

grant connect to ACCOUNT;

grant resource to ACCOUNT;

-- Grant/Revoke system privileges

grant unlimited tablespace to ACCOUNT;