create user xxx identified by sssss default tablespace users; grant connect to xxx;
你拼写的有点不对 create user zhang identified by password;
CREATE USER username IDENTIFIED BY password DEFAULT TABLESPACE users TEMPORARY TALBESPACE temp QUOTA UNLIMITED ON users;try it!
-- Create the user create user name identified by pwd default tablespace SYSTEM temporary tablespace temp profile DEFAULT; -- Grant/Revoke role privileges grant dba to name with admin option;
create user zhang identified by password; grant connect to zhang;
grant connect to xxx;
create user zhang identified by password;
DEFAULT TABLESPACE users
TEMPORARY TALBESPACE temp
QUOTA UNLIMITED ON users;try it!
create user name
identified by pwd
default tablespace SYSTEM
temporary tablespace temp
profile DEFAULT;
-- Grant/Revoke role privileges
grant dba to name with admin option;
grant connect to zhang;