数据库创建用户

2019独角兽企业重金招聘Python工程师标准>>>

在plsql users文件夹下选择一个用户可以看到语句

-- Create the user 

create user ZHUSHUANG

  identified by "123"

  default tablespace SDEFAULT

  temporary tablespace STMP

  profile DEFAULT;

-- Grant/Revoke role privileges 

grant connect to ZHUSHUANG;

grant dba to ZHUSHUANG;

grant resource to ZHUSHUANG;

-- Grant/Revoke system privileges 

grant unlimited tablespace to ZHUSHUANG;

转载于:https://my.oschina.net/u/1458291/blog/396731