create user m61
identified by m61
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to m61;
grant resource to m61;
-- Grant/Revoke system privileges
grant unlimited tablespace to m61;
本文介绍了一个具体的Oracle数据库操作案例,包括创建用户m61并设置默认表空间为USERS、临时表空间为TEMP,以及授予CONNECT和RESOURCE权限,并赋予无限表空间权限。
create user m61
identified by m61
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to m61;
grant resource to m61;
-- Grant/Revoke system privileges
grant unlimited tablespace to m61;

被折叠的 条评论
为什么被折叠?