OracleÓû§¹ÜÀí

oracleÓû§¹ÜÀí
                           
                           
ÖÆ×÷ÈË£ºÏòÏȺ¯
ÈÕÆÚ   2009-5-21
 
Æô¶¯-------------------------------------------------------------------
 
Æô¶¯¼àÌý        Lsnrctl start ;
 
Æô¶¯ÊµÀý        oradim  -starup –sid orcl;
 
ȨÏÞ£º-----------------------------------------------------------------
 
´´½¨Óû§        create user lisi identified by lisi ;
 
´´½¨Óû§È¨ÏÞ    grant create session to lisi;
 
´´½¨±íȨÏÞ      grant create table to lisi;
 
´´½¨±í¿Õ¼äȨÏÞ  grant unlimited tablespace to lisi;
 
³·ÏúȨÏÞ        revoke create table from lisi;
 
²é¿´È¨ÏÞ        select * from user_sys_privs;(ÆäÖÐuser_sys_privsÊÇÒ»¸öÊÓͼ)£¨ÏµÍ³£©
 
²é¿´µ±Ç°ÊÚȨ    select * from user_tab_privs;(ÆäÖÐuser_tab_privs Êǵ±Ç°ÊÓͼ)£¨¶ÔÏó£©
 
²é¿´ÁÐÓÃÊý¾Ý×Öµäcol select * from user_col_privs
 
³·ÏúʹÓÿռäµÄȨÏÞ  revoke unlimited tablespace from lisi;
 
²Ù×÷
 
²åÈëÒÔºó±ØÐëÊÖ¶¯Ìá½»²ÅÄÜÉúЧ   commit£»  ͬʱֻÓÐsysÓû§¿ÉÒÔ·ÃÎÊ
 
ÆÕͨÓû§ÊÚȨÈçÒªÔÚlisiÓû§ÀïÃæ·ÃÎÊwangwuµÄÓû§¾ÍÒªÉ趨
 
ÔÚwangwuÖР grant select on mytab to lisi;  (²éѯÊÚȨ)
              grant insert on mytab to lisi;  (²åÈëÊÚȨ)
              ¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£¡£
  &nb