oracle创建用户

oracle创建用户

方式1:

 

  上面4步都需要操作到位!!!

方式2:

把下面所有名为username和password单词改为你想要的用户名和密码
-- Create the user
create user username  IDENTIFIED BY password
  default tablespace SYSTEM
  temporary tablespace TEMP
  profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to username;
grant resource to username;
-- Grant/Revoke system privileges
grant unlimited tablespace to username;