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;

转载于:https://www.cnblogs.com/BradMiller/archive/2010/06/02/1750307.html