REVOKE
目录
REVOKE
NAMESYNOPSIS
DESCRIPTION æè¿°
NOTES 注æ
EXAMPLES ä¾å
COMPATIBILITY å¼å®¹æ§
SEE ALSO åè§
è¯è
è·
NAME
REVOKE - å é¤è®¿é®æé
SYNOPSIS
REVOKE [ GRANT
OPTION FOR ]
{ { SELECT | INSERT | UPDATE | DELETE | RULE | REFERENCES |
TRIGGER }
[,...] | ALL [ PRIVILEGES ] }
ON [ TABLE ] tablename [, ...]
FROM { username | GROUP groupname | PUBLIC }
[, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT
OPTION FOR ]
{ { CREATE | TEMPORARY | TEMP } [,...] | ALL [ PRIVILEGES ]
}
ON DATABASE dbname [, ...]
FROM { username | GROUP groupname | PUBLIC }
[, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT
OPTION FOR ]
{ EXECUTE | ALL [ PRIVILEGES ] }
ON FUNCTION funcname ([type, ...]) [, ...]
FROM { username | GROUP groupname | PUBLIC }
[, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT
OPTION FOR ]
{ USAGE | ALL [ PRIVILEGES ] }
ON LANGUAGE langname [, ...]
FROM { username | GROUP groupname | PUBLIC }
[, ...]
[ CASCADE | RESTRICT ]
REVOKE [ GRANT
OPTION FOR ]
{ { CREATE | USAGE } [,...] | ALL [ PRIVILEGES ] }
ON SCHEMA schemaname [, ...]
FROM { username | GROUP groupname | PUBLIC }
[, ...]
[ CASCADE | RESTRICT ]
DESCRIPTION æè¿°
REVOKE æ¤é以åèµäºï¼å«äººï¼çæéï¼å¯ä»¥æ¯æ¤éä¸ä¸ªæå¤ä¸ªç¨æ·æèä¸ç»ç¨æ·çæéã å³é®å PUBLIC 代表éå«å®ä¹çæ¥æææç¨æ·çç»ã
åé GRANT [grant(7)] å½ä»¤çæè¿°è·åæéç±»åçå«ä¹ã
请注æï¼ä»»ä½ç¹å®çç¨æ·é½å°æ¥æç´æ¥èµäºä»/她çæéï¼åä¸ä»/她æå¤çä»»ä½ç»ï¼ 以ååå ä¸èµäº PUBLIC çæéçæ»åãå æ¤ï¼ä¸¾ä¾æ¥è¯´ï¼åºæ¢ PUBLIC ç SELECT æé并ä¸æå³çææç¨æ·é½å¤±å»äºå¯¹è¯¥å¯¹è±¡ç SELECT æéï¼ é£äºç´æ¥å¾å°æéèµäºç以åéè¿ä¸ä¸ªç»å¾å°æéç人ä»ç¶æ¥æ该æéã
å¦æ声æäº GRANT OPTION FORï¼é£ä¹åªæ¯æ¤é对该æéçææçæåï¼èä¸æ¯æ¤é该æéæ¬èº«ã
å¦æä¸ä¸ªç¨æ·æææ项æéï¼å¹¶ä¸è¿æææçé项ï¼å¹¶ä¸è¿æè¿ä¸ªæéèµäºäºå¶ä»ç¨æ·ï¼ é£ä¹é£äºå¶ä»ç¨æ·ææçæéé½å«åä¾èµæ§æéã å¦æ第ä¸ä¸ªç¨æ·ææçæéæèææé项被æ¤éï¼èä¾èµæ§æéä»ç¶åå¨ï¼ é£ä¹å¦ææ们声æäº CASCADEï¼åææä¾èµæ§æéé½è¢«æ¤éï¼ å¦åæ¤éå¨ä½å°±ä¼å¤±è´¥ãè¿ä¸ªéè§çæ¤éåªå½±åé£ç§éè¿ä¸ä¸ªç¨æ·é¾èµäºçæéï¼ è¿ä¸ªé¾æ¡å¯ä»¥éè¿è¿æ¡ REVOKE å½ä»¤éé¢ç»åºçç¨æ·è¿½è¸ªã å æ- ¤ï¼å¦ææéæ¬èº«æ¯éè¿å¶ä»ç¨æ·èµäºçï¼ é£ä¹è¢«å½±åçç¨æ·å¯ä»¥ææå°ä¿çè¿ä¸ªæéã
NOTES 注æ
ä½¿ç¨ psql(1) ç \z å½ä»¤æ¾ç¤ºå¨ä¸ä¸ªç°å对象ä¸èµäºçæéã åè§ GRANT [grant(7)] è·åå³äºæ ¼å¼çä¿¡æ¯ã
ä¸ä¸ªç¨æ·åªè½æ¤éç±å®èªå·±ç´æ¥èµäºçæéã举ä¾æ¥è¯´ï¼å¦æç¨æ· A 带çææé项å§ä¸ä¸ªæéèµäºäºç¨æ· Bï¼ç¶åç¨æ· B åèµäºäºç¨æ· Cï¼ é£ä¹ç¨æ· A ä¸è½ç´æ¥å° C çæéæ¤éãä½æ¯ï¼ç¨æ· A å¯ä»¥æ¤éç¨æ· B çææé项ï¼å¹¶ä¸ä½¿ç¨ CASCADE é项ï¼è¿æ ·ï¼ ç¨æ· C çæéå°±ä¼èªå¨è¢«æ¤éã
å¦æä¸ä¸ªè¶çº§ç¨æ·ååºä¸ä¸ª GRANT æè REVOKE å½ä»¤ï¼ é£ä¹å½ä»¤æ¯æç§ä»¥è¢«å½±åç对象çææèæ§è¡çæ¹å¼æ§è¡çãå为æææéæç»ä»å¯¹è±¡ææèï¼å¯è½é´æ¥éè¿èµæé项è·åï¼ï¼ è¶çº§ç¨æ·å¯ä»¥åºé¤æææéï¼ä½æ¯è¿æ ·å°±è¦æ±åä¸é¢è¯´çé£æ ·ä½¿ç¨ CASCADEã
EXAMPLES ä¾å
æ¤éå¬ä¼å¨è¡¨ films ä¸çæå¥æéï¼
REVOKE INSERT ON films FROM PUBLIC;
åºé¤ç¨æ· manuel 对è§å¾ kinds çæææéï¼
REVOKE ALL PRIVILEGES ON kinds FROM manuel;
COMPATIBILITY å¼å®¹æ§
GRANT [grant(7)] å½ä»¤çå¼å®¹æ§ä¿¡æ¯åºæ¬ä¸ä¹éç¨äº REVOKEãè¯æ³æ¦è¦æ¯ï¼
REVOKE [ GRANT
OPTION FOR ] privileges
ON object [ ( column [, ...] ) ]
FROM { PUBLIC | username [, ...] }
{ RESTRICT | CASCADE }
æ åè¦æ± RESTRICT æè CASCADE ä¹ä¸å¿é¡»åºç°ï¼ ä½æ¯ PostgreSQL å设缺çæ¯ RESTRICTã
SEE ALSO åè§
GRANT [grant(7)]
è¯è
Postgresql ä¸æç½ç« ä½ä¼å¹³ <laser@pgsqldb.org>
è·
æ¬é¡µé¢ä¸æçç±ä¸æ
man
æå页计åæä¾ã
ä¸æ man
æå页计åï¼https://github.com/man-pages-zh/manpages-zh