Oracle创建用户和表空间-优快云博客

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

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

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;