oracle³£¼ûÓï¾ä

----±¾Óû§ËùÓµÓеÄϵͳȨÏÞ:
select * from user_sys_privs;
---±¾Óû§¶ÁÈ¡ÆäËûÓû§¶ÔÏóµÄȨÏÞ:
¡¡select * from user_tab_privs;
-----Ìí¼ÓȨÏÞ
GRANT CREATE USER,DROP  USER,ALTER USER ,CREATE ANY VIEW ,
DROP ANY  VIEW,EXP_FULL_DATABASE,IMP_FULL_DATABASE,
DBA,CONNECT,RESOURCE,CREATE  SESSION  TO Óû§Ãû£¨accor£©
-----´´½¨ÁÙʱ±í¿Õ¼ä
create temporary tablespace accor_ts
tempfile 'd:\accorDB'   ----‘Êý¾ÝÎļþ´æ·Å·¾¶’
size 32M                ----Îļþ´óС
autoextend on
next 32M maxsize 2048M
extent management local;
----´´½¨±í¿Õ¼ä
create tablespace accor_test
datafile 'd:\accorDataBase'    ----‘Êý¾ÝÎļþ´æ·Å·¾¶’
size 32M                       ----Îļþ´óС
autoextend on
next 32M maxsize 2048M
extent management local;
-----´´½¨Óû§
create user accor identified by accor(Óû§ÃÜÂë)
default tablespace accor_test    -----ĬÈϱí¿Õ¼ä
temporary tablespace accor_ts    -----ÁÙʱ±í¿Õ¼ä
----ɾ³ýÓû§
---- Óû§Ï´æÔÚ¶ÔÏ󣬱íʾҪÁ¬´ø¶ÔÏóÒ»Æðɾ³ý
    drop user accor cascade;
  ----  ×î¿ìµÄ°ì·¨ÊÇ£º
    conn /as sysdba
    delete from user$ where name='dzysc';
    commit;
    alter system flush shared_pool;
 
----¸øÓû§ÊÚȨ
grant connect,resource,create session,dba to accor
--¸ü»»Óû§µÇ½  disconnect    
   conn username/password@ʵÀýID
select * from user_sys_privs;
µ¼³öÃüÁ
exp uat_acc/uat_acc@ACCOR file=./uat_accor_0429.dmp  owner=uat_acc;
µ¼ÈëÃüÁ
imp uat_acc2/uat_acc2@ACCOR file=./test_acc_0413.dmp  fromuser=uat_acc2 touser=uat_acc2;