--创建用户
CREATE USER username IDENTIFIED BY userpwd
DEFAULT TABLESPACE TS_name1 --默认表空间
TEMPORARY TABLESPACE TS_name2; --临时表空间
--授权
-- Grant/Revoke role privileges
GRANT CONNECT TO username ;
GRANT DBA TO username ;
GRANT resource TO username ;
-- Grant/Revoke system privileges
grant unlimited tablespace to username ; --(可选)
阅读(1313) | 评论(0) | 转发(0) |
