ORACLE 10G创建表空间和创建用户

Edens_Song

于 2009-11-06 14:47:00 发布

阅读量425

点赞数

分类专栏：数据库文章标签： oracle user logging table

本文链接：https://blog.youkuaiyun.com/sony87615/article/details/4776515

版权

数据库专栏收录该内容

10 篇文章

订阅专栏

本文介绍了如何在Oracle数据库中创建表空间及数据文件，并详细展示了创建用户的过程，包括设置用户的默认表空间、临时表空间、权限分配以及配额限制。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

1、创建表空间

CREATE TABLESPACE mytablespace DATAFILE
'F:/oracle/product/10.2.0/oradata/myoracle/MYTABLESPACE01.DBF' SIZE 500M AUTOEXTEND ON NEXT

100M MAXSIZE UNLIMITED
LOGGING
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;

2、创建用户

CREATE USER ECC_NOTE IDENTIFIED BY sys
PROFILE DEFAULT
DEFAULT TABLESPACE mytablespace
TEMPORARY TABLESPACE temp
ACCOUNT UNLOCK;

GRANT UNDER ANY TABLE TO ECC_NOTE WITH ADMIN OPTION;

GRANT UNDER ANY TYPE TO ECC_NOTE WITH ADMIN OPTION;

GRANT UNDER ANY VIEW TO ECC_NOTE WITH ADMIN OPTION;

GRANT "DBA" TO ECC_NOTE WITH ADMIN OPTION;
GRANT "OLAP_DBA" TO ECC_NOTE WITH ADMIN OPTION;
GRANT "OLAP_USER" TO ECC_NOTE WITH ADMIN OPTION;
GRANT "SELECT_CATALOG_ROLE" TO ECC_NOTE WITH ADMIN OPTION;
ALTER USER ECC_NOTE DEFAULT ROLE "DBA", "OLAP_DBA", "OLAP_USER", "SELECT_CATALOG_ROLE";

ALTER USER test QUOTA UNLIMITED ON ECC_NOTE;