Oracle 创建数据库+添加权限

--创建两个数据库的文件（monitor.dbf 和monitor_temp.dbf 两个文件）
CREATE TABLESPACE monitor LOGGING DATAFILE 'C:\install\DB\oracle\app\oracle\oradata\xe\monitor.dbf'
SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 1000M EXTENT MANAGEMENT LOCAL;

create temporary tablespace monitor_temp tempfile 'C:\install\DB\oracle\app\oracle\oradata\xe\monitor_temp.dbf'
size 100m autoextend on next 32m maxsize 1000M extent management local;

--创建用户与上面创建的文件形成映射关系（用户名为monitor,密码为monitor）
CREATE USER monitor IDENTIFIED BY monitor DEFAULT TABLESPACE monitor TEMPORARY TABLESPACE monitor_temp;

--添加权限
grant connect,resource,dba to monitor;
grant create session to monitor;

--创建两个数据库的文件（TS_KA_DATA.dbf 和TS_KA_DATA_temp.dbf 两个文件）
CREATE TABLESPACE TS_KA_DATA LOGGING DATAFILE 'C:\install\DB\oracle\app\oracle\oradata\xe\TS_KA_DATA.dbf'
SIZE 100M AUTOEXTEND ON NEXT 32M MAXSIZE 1000M EXTENT MANAGEMENT LOCAL;

create temporary tablespace TS_KA_DATA_temp tempfile 'C:\install\DB\oracle\app\oracle\oradata\xe\TS_KA_DATA_temp.dbf'
size 100m autoextend on next 32m maxsize 1000M extent management local;

--创建用户与上面创建的文件形成映射关系（用户名为generalDB,密码为generalDB）
CREATE USER generalDB IDENTIFIED BY generalDB DEFAULT TABLESPACE TS_KA_DATA TEMPORARY TABLESPACE TS_KA_DATA_temp;

--添加权限
grant connect,resource,dba to generalDB;
grant create session to generalDB;

转载于:https://www.cnblogs.com/xiaohaizhuimeng/p/10969079.html