CREATE USER

NAME
SYNOPSIS
DESCRIPTION æè¿°
PARAMETERS åæ°
NOTES 注æ
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
SEE ALSO åè§
è¯è
è·

---

NAME

CREATE USER - å建ä¸ä¸ªæ°çæ°æ®åºç¨æ·å¸æ·

SYNOPSIS

CREATE USER name [ [ WITH ] option [ ... ] ]

where option can be:

SYSID uid
| [ ENCRYPTED | UNENCRYPTED ] PASSWORD ’password’
| CREATEDB | NOCREATEDB
| CREATEUSER | NOCREATEUSER
| IN GROUP groupname [, ...]
| VALID UNTIL ’abstime’

DESCRIPTION æè¿°

CREATE USER åä¸ä¸ª PostgreSQL æ°æ®åºé群å¢å ä¸ä¸ªæ°ç¨æ·ã åè Chapter 17 ‘‘Database Users and Privileges’’ å Chapter 19 ‘‘Client Authentication’’ è·åå³äºç®¡çç¨æ·å认è¯çä¿¡æ¯ã è¦æ§è¡è¿æ¡å½ä»¤ï¼ä½ å¿é¡»æ¯ä¸ä¸ªæ°æ®åºè¶çº§ç¨æ·ã

PARAMETERS åæ°

name

ç¨æ·å

uid

SYSID åå¥å¯ä»¥ç¨äºéæ©æ£å¨è¢«å建çç¨æ·ç PostgreSQL ç¨æ·æ è¯ã é常è¿æ¯ä¸å¿è¦çï¼ä½æ¯å¦æä½ æ³æ¢å¤ä¸ä¸ªå- ¤å¿å¯¹è±¡çææèï¼ä¹è®¸è¿ä¸ªå¾æç¨ã

å¦æ没æ声æè¿ä¸ªï¼ç¼ºç使ç¨å·²åéçæé«ç¨æ·æ è¯å ä¸ï¼æå°æ¯ 100ï¼ã

password

设置ç¨æ·çå£ä»¤ï¼å¦æä½ ä¸åå¤ä½¿ç¨å£ä»¤è®¤è¯ï¼ é£ä¹ä½å¯ä»¥çç¥è¿ä¸ªé项ï¼ä½å¦æä½æ³åæ¢å°ä¸ä¸ªå£ä»¤è®¤è¯çæå¡å¨ï¼é£ä¹è¯¥ç¨æ·å°ä¸è½èæ¥ã æ¤å£ä»¤å¯ä»¥ç¨åå次设置æèä¿®æ¹ï¼ä½¿ç¨ ALTER USER [alter_user(7)]ã

ENCRYPTED
UNENCRYPTED

æ§å¶å£ä»¤å¨æ°æ®åºä¸æ¯å¦ä»¥å å¯å½¢å¼åå¨å¨ç³»ç»è¡¨ä¸ã ï¼å¦æ两个é½æ²¡æ设置ï¼é£ä¹ç¼ºççç¹æ§æ¯ç±éç½®åæ° password_encryption å³å®çãï¼ å¦ææä¾çå串已ç»æ¯ MD5 å å¯çæ ¼å¼ï¼é£ä¹å°±ç§åæ ·åå¨ï¼ ä¸ç®¡å£°æçæ¯ ENCRYPTED è¿æ¯ UNENCRYPTEDã è¿æ ·å°±å许å¨è½¬å¨/æ¢å¤çè¿ç¨ä¸éè½½å å¯åçå£ä»¤ã

请注æèç客æ·ç«¯å¯è½ç¼ºå° MD5 认è¯æºå¶ï¼æ们éè¦è¿ä¸ªè®¤è¯æºå¶å¤çåå¨ä¸ºå¯æçå£ä»¤ã

CREATEDB
NOCREATEDB

è¿ä¸ªåå¥å®ä¹ç¨æ·çå建æ°æ®åºæéã å¦æ声æäºCREATEDBï¼ è¢«å®ä¹çç¨æ·å°å许å建å¶èªå·±çæ°æ®åºã è使ç¨NOCREATEDBå°å¦å³è¯¥ç¨æ·çå建æ°æ®åºçè½åã å¦æ忽ç¥æ¬å- å¥ï¼ç¼ºçæ¯NOCREATEDBã

CREATEUSER
NOCREATEUSER

该åå¥å³å®ä¸ä¸ªç¨æ·æ¯å¦è½å建ä¸ä¸ªæ°çç¨æ·ã è¿ä¸ªé项åæ ·ææ- ¤ç¨æ·åææ°æ®åºè¶çº§ç¨æ·ï¼å¯ä»¥è·¨è¶ææ访é®éå¶ãçç¥è¿ä¸ªåæ°å°ç½®ç¨æ·çè¿ä¸ªå±æ§ä¸º NOCREATEUSERã

groupname

ä¸ä¸ªç»å称ï¼æè¿ä¸ªç¨æ·è®¾ä¸ºè¯¥ç»æåã ä½ å¯ä»¥ååºå¤ä¸ªç»ååã

abstime

VALID UNTIL ï¼æææï¼åå¥è®¾ç½®ä¸ä¸ªç»å¯¹æ¶é´ï¼ è¿äºè¯¥æ¶é´åç¨æ·çå£ä»¤å°ä¸åææã å¦æçç¥è¿ä¸ªåå¥ï¼ç»éå°æ»æ¯ææçã

NOTES 注æ

ä½¿ç¨ ALTER USER [alter_user(7)] ä¿®æ¹ç¨æ·çå£ä»¤åæéï¼DROP USER [drop_user(7)] å é¤ä¸ä¸ªç¨æ·ã ä½¿ç¨ ALTER GROUP [alter_group(l)] ä»ç»ä¸å¢å æå é¤ç¨æ·ã

PostgreSQL éæä¸ä¸ªç¨åº createuser [createuser(1)] ä¸CREATE USER æç¸åçåè½ï¼å®éä¸ï¼å®è°ç¨è¿æ¡å½ä»¤ï¼ï¼ ä½æ¯å¯ä»¥å¨å½ä»¤è¡ä¸è¿è¡ã

EXAMPLES ä¾å

å建ä¸ä¸ªæ²¡æå£ä»¤çç¨æ·ï¼

CREATE USER jonathan;

å建ä¸ä¸ªæå£ä»¤çç¨æ·ï¼

CREATE USER davide WITH PASSWORD ’jw8s0F4’;

å建ä¸ä¸ªæå£ä»¤çç¨æ·ï¼å¶å¸å·å¨ 2004 å¹´åºå¤±æã 注æå½ 2005 å¹´èµ°è¿ä¸ç§åï¼è¯¥å¸å·å°ä¸åææï¼

CREATE USER miriam WITH PASSWORD ’jw8s0F4’ VALID UNTIL ’2005-01-01’;

å建ä¸ä¸ªæ¥æå建æ°æ®åºæéçç¨æ·ï¼

CREATE USER manuel WITH PASSWORD ’jw8s0F4’ CREATEDB;

COMPATIBILITY å¼å®¹æ§

CREATE USER è¯å¥æ¯ PostgreSQL æ©å±ã SQL æ åæç¨æ·çå®ä¹äº¤ç»å·ä½å®ç°å¤çã

SEE ALSO åè§

ALTER USER [alter_user(7)], DROP USER [drop_user(l)], createuser(1)

è¯è

Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>

è·

æ¬é¡µé¢ä¸æçç±ä¸æ man æå页计åæä¾ã
ä¸æ man æå页计åï¼https://github.com/man-pages-zh/manpages-zh

---