ORACLE 创建表空间用户、授予权限
注意：每条语语分开执行，结尾必须用分号;
//创建空间

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

//创建用户

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;--授予 查询 任何字典
 
grant dba to lxg;
grant unlimited tablespace to lxg;
grant select any table to lxg;
grant select any dictionary to lxg;