oracle创建用户

alanland

1.

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

2.

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

3.

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

4.

1. drop user "lxg" cascade

5.

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

6.

1. create user userName identified by password;

7.

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

没了