oracle表空间权限赋予,Oracle 创建用户、表空间以及授予权限

删除用户以及跟用户关联的对象

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;