DB/Oracle/¥³¥Þ¥ó¥É/¥æ¡¼¥¶´ÉÍý
Ìܼ¡ †
¥æ¡¼¥¶¤Î´ÉÍý¡£ºî¤Ã¤¿¤ê¾Ã¤·¤¿¤ê¡¢¸¢¸Â¤ò¤¢¤¿¤¨¤¿¤ê¡£
¥æ¡¼¥¶¤ÎºîÀ® †
¥æ¡¼¥¶¤òºî¤ë¡£¤¹¤Ù¤Æ¤Ï¤³¤³¤«¤é¡£
ÊýË¡ †
- ¥æ¡¼¥¶¤òºîÀ®¤¹¤ë
- ¥ª¥×¥·¥ç¥ó¤Î°ÕÌ£¤Ï°Ê²¼¡£ÂçÂ諤¿¤Þ¤Þ¤À¤±¤É
¥ª¥×¥·¥ç¥ó ÀâÌÀ identified by <password> ¥Ñ¥¹¥ï¡¼¥É default tablespace <tablespace-name> ¥Ç¥Õ¥©¥ë¥ÈɽÎΰè temporary tablespace <tablespace-name> °ì»þɽÎΰè quota <size>
on <tablespace>ɽÎΰè¤Ç¤Î³äÅöÀ©¸Â¡£¥»¥°¥á¥ó¥È¤òºî¤ë¤È¤¤Ëɬ¿Ü
- ¥ª¥×¥·¥ç¥ó¤Î°ÕÌ£¤Ï°Ê²¼¡£ÂçÂ諤¿¤Þ¤Þ¤À¤±¤É
Êä †
- ¥Ç¥Õ¥©¥ë¥ÈɽÎΰè¤ò»ØÄꤷ¤Ê¤«¤Ã¤¿¾ì¹ç¤Ï¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Ç¥Õ¥©¥ë¥ÈɽÎΰè¡Ê¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥¤¥ó¥¹¥È¡¼¥ë»þ¤Ë»ØÄê¡Ë¤Ç³ä¤êÅö¤Æ¤é¤ì¤ë¡£¥Ç¡¼¥¿¥Ù¡¼¥¹¤Î¥Ç¥Õ¥©¥ë¥ÈɽÎΰ褬»ØÄꤵ¤ì¤Æ¤¤¤Ê¤±¤ì¤Ð SYSTEM ɽÎΰè¤Ë¤Ê¤ë
- ¸¢¸Â¤òÍ¿¤¨¤Ê¤¤¤È¤Ê¤Ë¤â¤Ç¤¤Ê¤¤¡£Àܳ¤¹¤é¤Ç¤¤Ê¤¤¡£É¬Íפʸ¢¸Â¤ò¹Í¤¨¤Æ¡¢Å¬µ¹ºî¤Ã¤¿¥æ¡¼¥¶¤Ë³ä¤êÅö¤Æ¤ë¤³¤È
¥æ¡¼¥¶ÄêµÁ¤ÎÊѹ¹ †
´û¸¥æ¡¼¥¶¤ÎÄêµÁ¤ò¤¤¤¸¤¯¤ê¤Þ¤ï¤¹¡£Êѹ¹¤·¤¿¤¤¥ª¥×¥·¥ç¥ó¤òÎóµó¤¹¤ì¤Ð¡¢¥æ¡¼¥¶Ì¾°Ê³°¤ÏÊѹ¹²Äǽ¡£
ÊýË¡ †
- ¥æ¡¼¥¶ÄêµÁ¤òÊѹ¹¤¹¤ë
alter user <user-name> ... <options> ... ;
¥æ¡¼¥¶¤Îºï½ü †
¥æ¡¼¥¶¤òËõ¾Ã¤¹¤ë¡£
ÊýË¡ †
- ¥æ¡¼¥¶¤òºï½ü¤¹¤ë
¥·¥¹¥Æ¥à¸¢¸Â¤ÎÉÕÍ¿¤È¼è¾Ã †
¥·¥¹¥Æ¥à¸¢¸Â¤òÍ¿¤¨¤¿¤êÃ¥¤Ã¤¿¤ê¤¹¤ë¡£Ï¢º¿¤·¤Ê¤¤·Ï¸¢¸Â¡£
ÊýË¡ †
- ¥·¥¹¥Æ¥à¸¢¸Â¤ÎÉÕÍ¿¤ä¼è¾Ã¤ò¹Ô¤¦
¸¢¸Â¤ÎÎã †
¤¤¤í¤¤¤í¤¢¤ë¤Î¤Ç¤¤¤¯¤Ä¤«¥µ¥ó¥×¥ë¡£
- ¥µ¥ó¥×¥ë
¥ª¥Ö¥¸¥§¥¯¥È¸¢¸Â¤ÎÉÕÍ¿¤È¼è¾Ã †
¥ª¥Ö¥¸¥§¥¯¥È¸¢¸Â¤òÍ¿¤¨¤¿¤êÃ¥¤¤µî¤Ã¤¿¤ê¡£
ÊýË¡ †
- ¥ª¥Ö¥¸¥§¥¯¥È¸¢¸Â¤ÎÉÕÍ¿¤ä¼è¾Ã¤ò¹Ô¤¦
¸¢¸Â¤ÎÎã †
¤¤¤í¤¤¤í¤¢¤ë¤Î¤Ç¤³¤ì¤â¤¤¤¯¤Ä¤«¥µ¥ó¥×¥ë¡£
- ¥µ¥ó¥×¥ë
¥æ¡¼¥¶¤ä¸¢¸Â¤Ë´Ø¤¹¤ë¾ðÊó¤Î³Îǧ †
¥æ¡¼¥¶¤Ë´Ø¤¹¤ë¾ðÊó¤Î³Îǧ †
¥æ¡¼¥¶´Ø·¸¤Î¾ðÊó¤Ï¤À¤¤¤¿¤¤¤³¤³¤é¤Ç¤ï¤«¤ë¡£
- dba_users
- dba_ts_quptas
¸¢¸Â¤Ë´Ø¤¹¤ë¾ðÊó¤Î³Îǧ †
¸¢¸Â¤Þ¤ï¤ê¤Ï¤³¤Ã¤Á¡£
- dba_sys_privs
- dba_tab_privs
Last-modified: 2011-11-02 (¿å) 09:55:59