ORACLE 新建用户脚本

 -- Create the user 

create user oral

  identified by oral

  default tablespace USERS

  temporary tablespace TEMP

  profile DEFAULT;

-- Grant/Revoke role privileges 

grant dba to oral with admin option;

-- Grant/Revoke system privileges 

grant unlimited tablespace to oral with admin option;