--create user SP0704166,Password:lijuan
CREATE USER SP0712366
IDENTIFIED BY meijuan
DEFAULT TABLESPACE BACH
TEMPORARY TABLESPACE TEMP01
PROFILE DEFAULT;
--or grant user SP0704166 some privileges
GRANT CREATE SESSION,CREATE ANY TABLE,SELECT ANY TABLE,DELETE ANY TABLE,INSERT ANY TABLE,UPDATE ANY TABLE
TO SP0712366;
CREATE USER SP0712366
IDENTIFIED BY meijuan
DEFAULT TABLESPACE BACH
TEMPORARY TABLESPACE TEMP01
PROFILE DEFAULT;
--or grant user SP0704166 some privileges
GRANT CREATE SESSION,CREATE ANY TABLE,SELECT ANY TABLE,DELETE ANY TABLE,INSERT ANY TABLE,UPDATE ANY TABLE
TO SP0712366;