刚好学了这个。 CREATE USER 用户 IDENTIFIED BY 用户密码; COMMIT; GRANT DBA, CONNECT TO 用户; 授权用户 ALTER USER test DEFAULT TABLESPACE users QUOTA UNLIMITED ON users; ALTER USER test TEMPORARY TABLESPACE temp; COMMIT;CONNECT admin/yong1028@tb;
刚才把最下面的改一下: CREATE USER 用户 IDENTIFIED BY 用户密码; COMMIT; GRANT DBA, CONNECT TO 用户; 授权用户 ALTER USER test DEFAULT TABLESPACE users QUOTA UNLIMITED ON users; ALTER USER test TEMPORARY TABLESPACE temp; COMMIT;CONNECT 用户/用户密码;
create user ... identified by ...;
不可能。
scott/tiger
system/manager
都是normal用户
也是normal用户?
CREATE USER 用户 IDENTIFIED BY 用户密码;
COMMIT;
GRANT DBA, CONNECT TO 用户; 授权用户
ALTER USER test DEFAULT TABLESPACE users QUOTA UNLIMITED ON users;
ALTER USER test TEMPORARY TABLESPACE temp;
COMMIT;CONNECT admin/yong1028@tb;
CREATE USER 用户 IDENTIFIED BY 用户密码;
COMMIT;
GRANT DBA, CONNECT TO 用户; 授权用户
ALTER USER test DEFAULT TABLESPACE users QUOTA UNLIMITED ON users;
ALTER USER test TEMPORARY TABLESPACE temp;
COMMIT;CONNECT 用户/用户密码;