oracle創(chuàng)建用戶

alanland

1.

1. //創(chuàng)建空間
   
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創(chuàng)建用戶權限
   
2. //創(chuàng)建用戶
   
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;

沒了