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/p/1750307.html