Oracle 10g创建表空间和创建用户命令

最新推荐文章于 2020-09-11 18:42:09 发布

最新推荐文章于 2020-09-11 18:42:09 发布 · 194 阅读

文章标签：

#Oracle

sql 专栏收录该内容

8 篇文章

订阅专栏

本文介绍了如何使用Oracle数据库创建表空间及用户，并授予相应的权限。包括设置表空间的数据文件、大小、扩展方式等属性，以及为用户指定默认表空间、临时表空间、配额，并赋予特定角色。

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

创建表空间

CREATE TABLESPACE test DATAFILE 
  'D:\ORACLE\PRODUCT\10.1.0\ORADATA\ORACLE\TEST1.DBF' SIZE 500M AUTOEXTEND ON NEXT 100M MAXSIZE UNLIMITED
LOGGING
PERMANENT
EXTENT MANAGEMENT LOCAL AUTOALLOCATE
BLOCKSIZE 8K
SEGMENT SPACE MANAGEMENT MANUAL
FLASHBACK ON;

创建用户

CREATE USER test IDENTIFIED BY "test"
 DEFAULT TABLESPACE "TEST"
 TEMPORARY TABLESPACE "TEMP"
 PROFILE DEFAULT
 QUOTA UNLIMITED ON "TEST";

GRANT UNDER ANY TABLE TO test WITH ADMIN OPTION;

GRANT UNDER ANY TYPE TO test WITH ADMIN OPTION;

GRANT UNDER ANY VIEW TO test WITH ADMIN OPTION;


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

ALTER USER test QUOTA UNLIMITED ON TEST;