oracle创建用户

1.

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

2.

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

3.

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

4.

drop user "lxg" cascade

5.

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

6.

create user userName identified by password;

7.

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

没了