删除用户以及跟用户关联的对象
DROP USER 用户名称 CASCADE;
删除表空间
DROP TABLESPACE 表空间名称
INCLUDING CONTENTS AND DATAFILES;
创建表空间
create
tablespace表空间名
logging
datafile
'D:\oracle\product\10.2.0\oradata\orcl\hnxnb_data.dbf'
size
50m
autoextend on
next 50m
maxsize 20480m
extent
management local;
给表空间指定到指定的对象
CREATE
USER 用户名称IDENTIFIED BY 密码DEFAULT TABLESPACE 表空间名
TEMPORARY
TABLESPACE temp;
--授权对象权限
GRANT
CONNECT, RESOURCE,DBA TO用户名称;
GRANT
UNLIMITED TABLESPACE TO 用户名称;
GRANT
CREATE VIEW TO 用户名称;
GRANT
CREATE ANY PROCEDURE TO 用户名称;
GRANT
DEBUG ANY PROCEDURE TO 用户名称;
GRANT
DEBUG CONNECT SESSION TO 用户名称;
--用sys用户
GRANT
EXECUTE ON DBMS_PIPE TO 用户名称;
例子
=============================================================================================
--删除用户以及跟用户关联的对象
DROP USER bpnet CASCADE;
--删除表空间
DROP TABLESPACE bpnet_ts
INCLUDING CONTENTS AND DATAFILES;
--创建表空间
create tablespace bpnet_ts
logging
datafile
'D:\oracle\product\10.2.0\oradata\orcl\bpnet_ts.dbf'
size 10m
autoextend on
next 10m maxsize 100m
extent management local;
--给表空间指定到指定的对象
CREATE USER bpnet IDENTIFIED BY
bpnet DEFAULT TABLESPACE bpnet_ts
TEMPORARY TABLESPACE temp;
--授权对象权限
GRANT CONNECT, RESOURCE,DBA TO
bpnet;
GRANT UNLIMITED TABLESPACE TO
bpnet;
GRANT CREATE VIEW TO bpnet;
GRANT CREATE ANY PROCEDURE TO
bpnet;
GRANT DEBUG ANY PROCEDURE TO
bpnet;
GRANT DEBUG CONNECT SESSION TO
bpnet;