Oracle创建用户和表空间

最新推荐文章于 2024-03-17 11:07:50 发布

原创最新推荐文章于 2024-03-17 11:07:50 发布 · 631 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#Oracle

Database 专栏收录该内容

3 篇文章

订阅专栏

本文介绍如何在Oracle数据库中创建用户并分配相应的权限，包括创建表空间、授予连接资源和各种数据库对象创建权限等步骤。

1.创建用户，并分配权限

-- 数据目录根据实际环境替换
--创建用户表空间
CREATE TABLESPACE namespace DATAFILE
'/home/app/oracle/oradata/func27/namespace.dbf' SIZE 500M AUTOEXTEND ON NEXT 10M MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

--创建用户
--appuser
CREATE USER appuser
IDENTIFIED BY appuser
DEFAULT TABLESPACE namespace
PROFILE DEFAULT
ACCOUNT UNLOCK;

GRANT CONNECT TO appuser;
GRANT RESOURCE TO appuser;
GRANT CREATE SYNONYM TO appuser;
ALTER USER appuser DEFAULT ROLE ALL;
GRANT UNLIMITED TABLESPACE TO appuser;
ALTER USER appuser QUOTA UNLIMITED ON app;

--创建用户
--app
CREATE USER app
IDENTIFIED BY app
DEFAULT TABLESPACE app
PROFILE DEFAULT
ACCOUNT UNLOCK;

GRANT CONNECT TO app;
GRANT RESOURCE TO app;
GRANT CREATE ANY SYNONYM TO app;
GRANT CREATE PROCEDURE TO app;
GRANT CREATE VIEW TO app;
GRANT CREATE SESSION TO app;
GRANT CREATE SEQUENCE TO app;
GRANT CREATE TABLE TO app;
ALTER USER app DEFAULT ROLE ALL;
GRANT UNLIMITED TABLESPACE TO app;
ALTER USER app QUOTA UNLIMITED ON app;