PostgreSQL ¥æ¡¼¥¶¥¬¥¤¥É
PrevNext

ALTER USER

Name

ALTER USER  --  ¥æ¡¼¥¶¥¢¥«¥¦¥ó¥È¾ðÊó¤òÊѹ¹¤¹¤ë

Synopsis

ALTER USER username [ WITH PASSWORD password ]
    [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
    [ IN GROUP groupname [, ...] ]
    [ VALID UNTIL 'abstime' ]

ÆþÎÏ

³Æ¶ç¤Î¾ÜºÙ¤Êµ­½Ò¤Ë¤Ä¤¤¤Æ¤ÏCREATE USER ¤ò »²¾È¡£

username

¤½¤Î¾ÜºÙ¤¬¹¹¿·¤µ¤ì¤ë¡¢¥æ¡¼¥¶¤ÎPostgres ¥¢¥«¥¦¥ó¥È̾

password

¤³¤Î¥¢¥«¥¦¥ó¥È¤ËÍѤ¤¤é¤ì¤ë¿·¤·¤¤¥Ñ¥¹¥ï¡¼¥É

groupname

¤³¤Î¥¢¥«¥¦¥ó¥È¤¬ÃÖ¤«¤ì¤ë¥¢¥¯¥»¥¹¥°¥ë¡¼¥×¤Î̾Á°

abstime

¤³¤Î¥æ¡¼¥¶¤Î¥¢¥¯¥»¥¹¤¬½ªÎ»¤¹¤ëÆüÉÕ(¤½¤·¤Æ¥ª¥×¥·¥ç¥ó¤Ç»þ¹ï)

½ÐÎÏ

ALTER USER

Êѹ¹¤¬À®¸ù¤·¤¿¾ì¹ç¤ËÊÖ¤ë¥á¥Ã¥»¡¼¥¸¡£

ERROR: alterUser: user "username" does not exist

»ØÄê¤Î¥æ¡¼¥¶¤¬¥Ç¡¼¥¿¥Ù¡¼¥¹¤ËǧÃΤµ¤ì¤Æ¤¤¤Ê¤¤¾ì¹ç¤ËÊÖ¤ë ¥á¥Ã¥»¡¼¥¸

ÀâÌÀ

ALTER USER ¤Ï¥æ¡¼¥¶¤Î Postgres ¥¢¥«¥¦¥ó¥È¤Î°À­¤òÊѹ¹¤¹¤ë ¤Î¤Ë»È¤ï¤ì¤Þ¤¹¡£ alter user ʸ¤Ç¤Ï¥æ¡¼¥¶¤Î"usesysid" ¤òÊѹ¹¤¹¤ë¤³¤È¤Ï¤Ç¤­¤Ê¤¤ ¤³¤È¤ËÃí°Õ¤·¤Æ²¼¤µ¤¤¡£ ¤Þ¤¿¡¢Postgres ¥æ¡¼¥¶¤ä¡¢ pg_shadow ¤òÆɤó¤À¤êÊѹ¹¤·¤¿¤ê¤Ç¤­¤ë¸¢¸Â¤Î¤¢¤ë ¥æ¡¼¥¶°Ê³°¤Ï¡¢¥æ¡¼¥¶¤Î¥Ñ¥¹¥ï¡¼¥É¤òÊѹ¹¤¹¤ë¤³¤È¤¬¤Ç¤­¤Þ¤»¤ó¡£

alter user ʸ¤Ë¤ª¤±¤ë³Æ¶ç¤Î¤¤¤º¤ì¤«¤¬¾Êά¤µ¤ì¤¿¾ì¹ç¡¢ "pg_shadow" ɽ¤Ë¤ª¤¤¤ÆÂбþ¤¹¤ëÃͤÏÊѹ¹¤µ¤ì¤Þ¤»¤ó¡£

Ãí°Õ»ö¹à

ALTER USER ¤Ï¡¢Postgres ¤Î¸À¸ì³ÈÄ¥¤Ç¤¹¡£

¥æ¡¼¥¶¥¢¥«¥¦¥ó¥È¤òºîÀ®¡¢ºï½ü¤¹¤ë¤Ë¤Ï CREATE/DROP USER ¤ò»²¾È¡£

¸½ºß¤Î¥ê¥ê¡¼¥¹(v6.5) ¤Ç¤Ï¡¢IN GROUP ¶ç¤Ï¹½Ê¸²òÀϤµ¤ì¤Þ¤¹¤¬ ²¿¤Î¸úÎϤ⤢¤ê¤Þ¤»¤ó¡£¥Õ¥ë¼ÂÁõ¤·¤¿¤¢¤«¤Ä¤­¤Ë¤Ï¡¢¤½¤Î¶ç ¤Ë¤è¤Ã¤Æpg_group ¥ê¥ì¡¼¥·¥ç¥ó¤¬¹¹¿·¤µ¤ì¤ëÍͤˤʤê¤Þ¤¹¡£

»ÈÍÑË¡

¥æ¡¼¥¶¤Î¥Ñ¥¹¥ï¡¼¥É¤òÊѹ¹¤¹¤ë: 

ALTER USER davide WITH PASSWORD hu8jmn3;
¥æ¡¼¥¶¤ÎÍ­¸ú´ü¸Â¤òÊѹ¹¤¹¤ë: 
ALTER USER manuel VALID UNTIL 'Jan 31 2030';
¥æ¡¼¥¶¤ÎÍ­¸ú´ü¸Â¤ò¡¢1»þ´Ö¿Ê¤ó¤ÀUTC ¥¿¥¤¥à¥¾¡¼¥ó¤òÍѤ¤¤Æ 1998ǯ5·î4Æü¤ÎÀµ¸á¤ËÇË´þ¤¹¤ë¤è¤¦¤Ê»ØÄê¤Ç ¥æ¡¼¥¶¤ÎÍ­¸ú´ü¸Â¤òÊѹ¹¤¹¤ë: 
ALTER USER chris VALID UNTIL 'May 4 12:00:00 1998 +1';
¥æ¡¼¥¶¤Ë¾¤Î¥æ¡¼¥¶¤È¿·¤·¤¤¥Ç¡¼¥¿¥Ù¡¼¥¹¤òºîÀ®¤¹¤ë¸¢¸Â¤òÍ¿¤¨¤ë: 
ALTER USER miriam CREATEUSER CREATEDB;
¥æ¡¼¥¶¤ò2 ¤Ä¤Î¥°¥ë¡¼¥×¤Ë°ÌÃÖÉÕ¤±¤ë: 
ALTER USER miriam IN GROUP sales, payroll;

¸ß´¹À­

SQL92

SQL92 ¤Ë¤ÏALTER USER ʸ¤Ï¤¢¤ê¤Þ¤»¤ó¡£ µ¬³Ê¤Ï¥æ¡¼¥¶¤ÎÄêµÁ¤ò¼ÂÁõ°Í¸¤Ë¤·¤Æ¤¤¤Þ¤¹¡£

PrevHomeNext
ALTER TABLEUpBEGIN