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;