oracle create tablespace and user

最新推荐文章于 2024-09-14 14:01:42 发布

toShareYou

最新推荐文章于 2024-09-14 14:01:42 发布

阅读量233

点赞数

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

本文链接：https://blog.csdn.net/u011984172/article/details/127627543

版权

oracle 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

create tablespace hisbase
logging
datafile 'E:\oracle\product\10.2.0\oradata\orcl\hisbase.ora'
size 512m
autoextend on
next 32m maxsize UNLIMITED
extent management local;

create temporary tablespace hisbase_temp
tempfile 'E:\oracle\product\10.2.0\oradata\orcl\hisbase_temp.ora'
size 128m
autoextend on
next 32m maxsize 2048m
extent management local;

-- Create the user HISBASE
create user HISBASE
identified by "1223"
default tablespace HISBASE
temporary tablespace HISBASE_TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to HISBASE with admin option;
grant dba to HISBASE with admin option;
grant resource to HISBASE with admin option;
-- Grant/Revoke system privileges
grant alter any index to HISBASE with admin option;
grant alter any procedure to HISBASE with admin option;
grant alter any table to HISBASE with admin option;
grant create any index to HISBASE with admin option;
grant create any procedure to HISBASE with admin option;
grant create any table to HISBASE with admin option;
grant create procedure to HISBASE with admin option;
grant create table to HISBASE with admin option;
grant delete any table to HISBASE with admin option;
grant execute any indextype to HISBASE with admin option;
grant execute any procedure to HISBASE with admin option;
grant insert any table to HISBASE with admin option;
grant select any sequence to HISBASE with admin option;
grant select any table to HISBASE with admin option;
grant unlimited tablespace to HISBASE with admin option;
grant update any table to HISBASE with admin option;