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