ALTER USER
目录
ALTER USER
NAMESYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
NOTES 注æ
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
SEE ALSO åè§
è¯è
è·
NAME
ALTER USER - æ¹åæ°æ®åºç¨æ·å¸å·
SYNOPSIS
ALTER USER name [ [ WITH ] option [ ... ] ]
where option can be:
[ ENCRYPTED |
UNENCRYPTED ] PASSWORD ’password’
| CREATEDB | NOCREATEDB
| CREATEUSER | NOCREATEUSER
| VALID UNTIL ’abstime’
ALTER USER name RENAME TO newname
ALTER USER
name SET parameter { TO | = } { value |
DEFAULT }
ALTER USER name RESET parameter
DESCRIPTION æè¿°
ALTER USER ç¨äºæ´æ¹ç¨æ·ç PostgreSQL å¸å·çå±æ§ã 没æå¨è¯¥å½ä»¤ä¸- åºç°çå±æ§ä¿æåå¼ã
è¿æ¡å½ä»¤æ¨¡å¼ä¸ç第ä¸ä¸ªåç§ä¿®æ¹æäºå¨å±ç¨æ·æéå认è¯è®¾ç½®ã ï¼è§ä¸æè·åç»èãï¼åªææ°æ®åºè¶çº§ç¨æ·å¯ä»¥ç¨è¿æ¡å½ä»¤æ¹åè¿äºæéå使å£ä»¤å¤±æãæ®éç¨æ·åªè½ä¿®æ¹å®ä»¬èªå·±çå£ä»¤ã
第äºä¸ªåç§æ¹åç¨æ·çååãåªææ°æ®åºè¶çº§ç¨æ·æè½éæ°å½åç¨æ·å¸æ·ã å½åä¼è¯ç¨æ·ä¸è½éå½åãï¼å¦ææ³è¿ä¹å¹²ï¼åç¨å¦å¤ä¸ä¸ªç¨æ·è´¦å·è¿æ¥ãï¼
第ä¸å第å个åç§ä¿®æ¹ç¨æ·ä¼è¯çç¹å®éç½®åéç缺çå¼ã å½è¯¥ç¨æ·éåå¯å¨ä¸ä¸ªæ°çä¼è¯æ¶ï¼å£°æçæ°å¼å°æ为ä¼è¯ç缺çï¼è¦ç ä»»ä½åºç°å¨ postgresql.conf éï¼æèä» postmaster å½ä»¤è¡æ¥æ¶å°ç设置ã æ®éç¨æ·å¯ä»¥ä¿®æ¹å®ä»¬èªå·±çä¼è¯ç¼ºçãè¶çº§ç¨æ·å¯ä»¥ä¿®æ¹ä»»ä½ç¨æ·ç缺çã
PARAMETERS åæ°
|
name |
æ³è¿è¡å±æ§æ´æ¹çç¨æ·ååã
password
æ¤å¸å·æ使ç¨çæ°å£ä»¤ã
ENCRYPTED
UNENCRYPTED
è¿äºå³é®åæ§å¶å£ä»¤æ¯å¦ä»¥å å¯å½¢å¼åå¨ pg_shadow éã ï¼åé CREATE USER [create_user(7)] è·åè¿ä¸ªé项çæ´å¤ä¿¡æ¯ãï¼
CREATEDB
NOCREATEDB
è¿ä¸ªåå¥å®ä¹è¯¥ç¨æ·å建æ°æ®åºçè½åã å¦æ声æäºCREATEDBï¼è¯¥ç¨æ·å¯ä»¥å建她èªå·±çæ°æ®åºã ç¨NOCREATEDBå°å¥å¤ºä¸ä¸ªç¨æ·å建æ°æ®åºçè½åã
CREATEUSER
NOCREATEUSER
è¿ä¸ªåå¥å³å®ä¸ä¸ªç¨æ·è½å¦å建æ°ç¨æ·ã è¿ä¸ªé项åæ ·è¿ä»¤è¯¥ç¨æ·æ为è¶çº§ç¨æ·ï¼å¯ä»¥è¶è¶ææ访é®éå¶ã
abstime
该ç¨æ·å¸å·å£ä»¤çè¿æçæ¥æï¼åå¯éçæ¶é´ï¼ã è¦è®¾ç½®ä¸ä¸ªå£ä»¤ä»ä¸è¿æï¼å¯ä»¥ç¨’infinity’ã
newname
ç¨æ·çæ°ååã
parameter
|
value |
æ该ç¨æ·ç¹å®çéç½®åéçä¼è¯ç¼ºç设置为ç»å®çæ°å¼ã å¦æ value 为 DEFAULT æè使ç¨äºçæç RESETï¼é£ä¹å é¤ç¨æ·ç¸å³çåéï¼ å¹¶ä¸è¯¥ç¨æ·å°å¨æ°ä¼è¯ä¸ç»§æ¿ç¼ºç设置ãä½¿ç¨ RESET ALL æ¸é¤ææ设置ã
åé SET [set(7)] å Section 16.4 ‘‘Run-time Configuration’’ è·åæå³å¯ç¨åéåæ°å¼çæ´å¤ä¿¡æ¯ã
NOTES 注æ
ä½¿ç¨ CREATE USER [create_user(7)] å建æ°ç¨æ·å DROP USER [drop_user(7)] å é¤ç¨æ·ã
ALTER USER æ æ³æ¹åä¸ä¸ªç¨æ·çç»çæåæ§ã ç¨ ALTER GROUP [alter_group(7)] å®ç°è¿ä¸ªç®å°ã
ä½¿ç¨ ALTER DATABASE [alter_database(7)]ï¼æ们è¿å¯è½æä¸ä¸ªä¼è¯ç¼ºçåæ个æ°æ®åºç»å®èµ·æ¥ï¼èä¸æ¯åæ个ç¨æ·ç»å®ã
EXAMPLES ä¾å
æ´æ¹ä¸ç¨æ·å£ä»¤ï¼
ALTER USER davide WITH PASSWORD ’hu8jmn3’;
æ´æ¹ä¸ç¨æ·æææï¼
ALTER USER manuel VALID UNTIL ’Jan 31 2030’;
æ´æ¹ä¸ç¨æ·æææï¼ å£°æå¶æéåºè¯¥å¨ç¨æ¯UTCæ©ä¸å°æ¶çæ¶åºè®°æ¶ç 2005 å¹´ 5 æ 4 æ¥æ£å失æ
ALTER USER chris VALID UNTIL ’May 4 12:00:00 2005 +1’;
令ç¨æ·æ°¸è¿ææï¼
ALTER USER fred VALID UNTIL ’infinity’;
èµäºä¸ç¨æ·å建æ°ç¨æ·åæ°æ°æ®åºçæéï¼
ALTER USER miriam CREATEUSER CREATEDB;
COMPATIBILITY å¼å®¹æ§
ALTER USER è¯å¥æ¯ PostgreSQL æ©å±ãSQL æ åå°ç¨æ·çå®ä¹äº¤ç»å®ç°å®æã
SEE ALSO åè§
CREATE USER [create_user(7)], DROP USER [drop_user(l)], SET [set(l)]
è¯è
Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>
è·
æ¬é¡µé¢ä¸æçç±ä¸æ
man
æå页计åæä¾ã
ä¸æ man
æå页计åï¼https://github.com/man-pages-zh/manpages-zh