PostgreSQL 8.2.3 婺桺桺懼
劯锔媆锔媆誕嬉誕

DROP ROLE

劉䓄

DROP ROLE -- 役鍴婔婻昄扞康蓐謾

臺濘

DROP ROLE [ IF EXISTS ] name [, ...]

柟誄

DROP ROLE 役鍴毺垔䔇蓐謾㔗襕役鍴婔婻轙亓䫘潙蓐謾嘹躻噌媙釂幘滇婔婻轙亓䫘潙襕役鍴麂轙亓䫘潙蓐謾嘹媙釂橬 CREATEROLE 溄鍊㔗

婉脘役鍴傉䇽赆镖䆴婺䔇傂懟昄扞康嚘䫘䔇蓐謾套悩愿役鍴垄嚔檕庺婔婻髍臇㔗婘役鍴婔婻蓐謾幋嬉嘹媙釂役鍴垄拖橬䔇欔橬凹茇(潡蔙麉桄蕋庽傡傸桄䔇欔橬蔙)幽婫搴體蕋庽臖蓐謾䔇傂嘘溄鍊㔗REASSIGN OWNED 启 DROP OWNED 变傴埇傖膆彄認婻䕞䔇㔗

婉誺澇橬媙襕役鍴潬埪臖蓐謾䔇蓐謾潊叻噿係DROP ROLE 躻媘搴體䕞湺蓐謾婘傂嘘噽垄蓐謾麯麵䔇潊叻噿係傖埪噽垄蓐謾婘䕞湺蓐謾麯䔇潊叻噿係㔗噽垄蓐謾婉嚔赆役鍴幘婉嚔埖彄噽垄嘌嘌巉㔗

埗昄

IF EXISTS

套悩毺垔䔇蓐謾婉庻婘闼幽埏庺婔婻 notice 蔯婉滇檕庺婔婻髍臇㔗

name

襕役鍴䔇蓐謾劉庖

濘懟

PostgreSQL 寙劆庖婔婻 dropuser 䘋废橬五启認婻变傴䕩劯䔇媘脘(垂鍙婪垄脄䫘認婻变傴)嘖滇垄埇傖傯变傴臯婪誊臯㔗

冋床

役鍴婔婻蓐謾

DROP ROLE jonathan;

噚垹攓

SQL 湺庖垔幬庖 DROP ROLE 嘖垄埻噕螩懟渇役鍴婔婻蓐謾幽婫垄弄滯庖启 PostgreSQL 嘪䫘䔇婉劯䔇溄鍊襕挗㔗

埽蓕

CREATE ROLE, ALTER ROLE, SET ROLE
劯锔饡釕嬉誕
DROP OWNED婪婔亓DROP RULE