Oracle创建表空间、临时表空间、创建用户和授权用户

Oracle基础 05/11 阅读 5197 views次 人气 923
摘要:

Oracle数据库,创建表空间、临时表空间、创建用户和授权用户,供复制使用。

1. 创建uum表空间

create tabluumace uum

datafile '/u01/oracle/oradata/uum/uum.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

 

2. 创建uum_tmp临时表空间

create temporary tabluumace uum_tmp

tempfile '/u01/oracle/oradata/uum/uum_tmp.dbf'

size 50m

autoextend on

next 50m maxsize 20480m

extent management local;

 

3. 创建uum用户

create user uum identified by 123456

default tabluumace uum temporary tabluumace uum_tmp

account unlock;

 

4. 授权uum用户

grant create session, create any table, create any view, create any index, create any procedure, alter any table, alter any procedure, drop any table, drop any view, drop any index, drop any procedure, select any table, insert any table, update any table, delete any table to uum;

grant create session to uum;

grant connect to uum;

grant resource to uum;

grant dba to uum;

 

 

评论

该文章不支持评论!

分享到: