创建表空间、创建用户（日常记录）

1 新建表空间

create tablespace MYSPACES
logging datafile 'F:/logging/MYSPACES.dbf' size 50m
autoextend on next 50m maxsize 20480m
extent management local;

2 删除表空间

DROP MYSPACES PSBCXMGL INCLUDING CONTENTS AND DATAFILES;

创建用户(用户名MYUSERS 密码MYUSERS)

1 创建新用户 给用户赋权限

创建用户：
CREATE USER MYUSERS PROFILE "DEFAULT" IDENTIFIED BY myusers DEFAULT TABLESPACE
MYSPACES;
赋权限：
GRANT "CONNECT" TO MYUSERS;

GRANT "RESOURCE" TO MYUSERS;

GRANT "DBA" TO MYUSERS;

GRANT create view TO MYUSERS;

2 删除用户

drop user MYUSERS cascade;

删除一个用户 表空间：

1 删除表空间
DROP TABLESPACE MYSPACES INCLUDING CONTENTS AND DATAFILES;
2 删除用户
drop user MYUSERS cascade;

 

转载于:https://www.cnblogs.com/tanhuayixian/p/6293227.html