oracle 创建表空间,用户,授权

 

1

 

create tablespace ami_tablespace logging datafile 'D:\oracle\oradata\ami_data.dbf' 

size 5000M autoextend on next 100M maxsize 30000M 

EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO; 

2

create user ami identified by vv default tablespace ami_tablespace; 

3

grant dba,connect,resource,create view  to ami;

 

grant dba to ami;--授予DBA权限  

grant unlimited tablespace to ami;--授予不限制的表空间  

grant select any table to ami;--授予查询任何表  

grant select any dictionary to ami;--授予 查询 任何字典 

 

--drop tablespace ami_tablespace including contents and datafiles;

--drop user ami  cascade;

 

--select * from dba_role_privs t where t.GRANTEE='AMI';

--select * from dba_sys_privs t where t.GRANTEE='AMI';

==============================

//创建空间
create tablespace test
datafile 'c:\oracle\oradata\orcl9\test.dbf' size 50M
default storage (initial 500K
Next 500K
minextents 1
maxextents unlimited
pctincrease 0);

//Oracle创建用户权限
//创建用户
create user lxg identified by lxg default tablespace test;
//授权
grant resource,connect,dba to test;

//删除表空间
drop tablespace "空间名" including contents and datafiles

删除用户 

drop user "lxg" cascade

增加表空间

alter tablespace chinawater add datafile 'c:\oracle\oradata\orcl9\ADDCHINAWATER.dbf' size 200M

创建用户

create user userName identified by password;

创建用户 userName,密码为 password

2

给用户授权

grant dba to lxg;--授予DBA权限
grant unlimited tablespace to lxg;--授予不限制的表空间
grant select any table to lxg;--授予查询任何表
grant select any dictionary to lxg;--授予 查询 任何字典