DB/Oracle/¥³¥Þ¥ó¥É/¥æ¡¼¥¶´ÉÍý

Top/DB/Oracle/¥³¥Þ¥ó¥É/¥æ¡¼¥¶´ÉÍý

Ìܼ¡

¥æ¡¼¥¶¤Î´ÉÍý¡£ºî¤Ã¤¿¤ê¾Ã¤·¤¿¤ê¡¢¸¢¸Â¤ò¤¢¤¿¤¨¤¿¤ê¡£


¥æ¡¼¥¶¤ÎºîÀ®

¥æ¡¼¥¶¤òºî¤ë¡£¤¹¤Ù¤Æ¤Ï¤³¤³¤«¤é¡£

ÊýË¡

  1. ¥æ¡¼¥¶¤òºîÀ®¤¹¤ë
    
    
    • ¥ª¥×¥·¥ç¥ó¤Î°ÕÌ£¤Ï°Ê²¼¡£ÂçÂ諤¿¤Þ¤Þ¤À¤±¤É
      ¥ª¥×¥·¥ç¥óÀâÌÀ
      identified by <password>¥Ñ¥¹¥ï¡¼¥É
      default tablespace <tablespace-name>¥Ç¥Õ¥©¥ë¥ÈɽÎΰè
      temporary tablespace <tablespace-name>°ì»þɽÎΰè
      quota <size>
      on <tablespace>
      ɽÎΰè¤Ç¤Î³äÅöÀ©¸Â¡£¥»¥°¥á¥ó¥È¤òºî¤ë¤È¤­¤Ëɬ¿Ü

Êä­

  • ¥Ç¥Õ¥©¥ë¥ÈɽÎΰè¤ò»ØÄꤷ¤Ê¤«¤Ã¤¿¾ì¹ç¤Ï¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Ç¥Õ¥©¥ë¥ÈɽÎΰè¡Ê¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥¤¥ó¥¹¥È¡¼¥ë»þ¤Ë»ØÄê¡Ë¤Ç³ä¤êÅö¤Æ¤é¤ì¤ë¡£¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Ç¥Õ¥©¥ë¥ÈɽÎΰ褬»ØÄꤵ¤ì¤Æ¤¤¤Ê¤±¤ì¤Ð SYSTEM ɽÎΰè¤Ë¤Ê¤ë
  • ¸¢¸Â¤òÍ¿¤¨¤Ê¤¤¤È¤Ê¤Ë¤â¤Ç¤­¤Ê¤¤¡£Àܳ¤¹¤é¤Ç¤­¤Ê¤¤¡£É¬Íפʸ¢¸Â¤ò¹Í¤¨¤Æ¡¢Å¬µ¹ºî¤Ã¤¿¥æ¡¼¥¶¤Ë³ä¤êÅö¤Æ¤ë¤³¤È

¥æ¡¼¥¶ÄêµÁ¤ÎÊѹ¹

´û¸¥æ¡¼¥¶¤ÎÄêµÁ¤ò¤¤¤¸¤¯¤ê¤Þ¤ï¤¹¡£Êѹ¹¤·¤¿¤¤¥ª¥×¥·¥ç¥ó¤òÎóµó¤¹¤ì¤Ð¡¢¥æ¡¼¥¶Ì¾°Ê³°¤ÏÊѹ¹²Äǽ¡£

ÊýË¡

  1. ¥æ¡¼¥¶ÄêµÁ¤òÊѹ¹¤¹¤ë
    alter user <user-name>
      ...
      <options>
      ...
    ;
    

¥æ¡¼¥¶¤Îºï½ü

¥æ¡¼¥¶¤òËõ¾Ã¤¹¤ë¡£

ÊýË¡

  1. ¥æ¡¼¥¶¤òºï½ü¤¹¤ë

¥·¥¹¥Æ¥à¸¢¸Â¤ÎÉÕÍ¿¤È¼è¾Ã

¥·¥¹¥Æ¥à¸¢¸Â¤òÍ¿¤¨¤¿¤êÃ¥¤Ã¤¿¤ê¤¹¤ë¡£Ï¢º¿¤·¤Ê¤¤·Ï¸¢¸Â¡£

ÊýË¡

  1. ¥·¥¹¥Æ¥à¸¢¸Â¤ÎÉÕÍ¿¤ä¼è¾Ã¤ò¹Ô¤¦

¸¢¸Â¤ÎÎã

¤¤¤í¤¤¤í¤¢¤ë¤Î¤Ç¤¤¤¯¤Ä¤«¥µ¥ó¥×¥ë¡£

  • ¥µ¥ó¥×¥ë

¥ª¥Ö¥¸¥§¥¯¥È¸¢¸Â¤ÎÉÕÍ¿¤È¼è¾Ã

¥ª¥Ö¥¸¥§¥¯¥È¸¢¸Â¤òÍ¿¤¨¤¿¤êÃ¥¤¤µî¤Ã¤¿¤ê¡£

ÊýË¡

  1. ¥ª¥Ö¥¸¥§¥¯¥È¸¢¸Â¤ÎÉÕÍ¿¤ä¼è¾Ã¤ò¹Ô¤¦

¸¢¸Â¤ÎÎã

¤¤¤í¤¤¤í¤¢¤ë¤Î¤Ç¤³¤ì¤â¤¤¤¯¤Ä¤«¥µ¥ó¥×¥ë¡£

  • ¥µ¥ó¥×¥ë

¥æ¡¼¥¶¤ä¸¢¸Â¤Ë´Ø¤¹¤ë¾ðÊó¤Î³Îǧ

¥æ¡¼¥¶¤Ë´Ø¤¹¤ë¾ðÊó¤Î³Îǧ

¥æ¡¼¥¶´Ø·¸¤Î¾ðÊó¤Ï¤À¤¤¤¿¤¤¤³¤³¤é¤Ç¤ï¤«¤ë¡£

  • dba_users
  • dba_ts_quptas

¸¢¸Â¤Ë´Ø¤¹¤ë¾ðÊó¤Î³Îǧ

¸¢¸Â¤Þ¤ï¤ê¤Ï¤³¤Ã¤Á¡£

  • dba_sys_privs
  • dba_tab_privs

Last-modified: 2011-11-02 (¿å) 09:55:59