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

ALTER GROUP

劉䓄

ALTER GROUP -- 媞櫹蓐謾劉潡蔙潊叻噿係

臺濘

ALTER GROUP groupname ADD USER username [, ... ]
ALTER GROUP groupname DROP USER username [, ... ]

ALTER GROUP groupname RENAME TO newname

柟誄

ALTER GROUP 媞櫹婔婻䫘潙䂇䔇匂攓㔗認滇婔溇誺施䔇变傴婉誺庺庯劏劯噚垹䔇寘啹誻赆毖埖啹婺䂇(埪䫘潙)鄘噾䂟赆敘婔轸䔇楗媕蓐謾䂍傼敪庖㔗

崘婴婻嘵嚟傯䂇婺嵂媹潡蔙役鍴䫘潙㔗傂嘘蓐謾鄘埇傖嘷嘩"䫘潙"潡蔙"䂇"準啔認婻庋愙㔗認婻埻嘷垂鍙婪京昽庯䂍变劉婺"䂇"䔇蓐謾劉蕋庽潡蔙搴體潊叻噿係啹溴啔認婻庋愙䔇懫膄喘䔇桹濘滇 GRANT 潡 REVOKE 㔗

丸婬䓉埻嘷媞櫹婔婻䂇䔇劉庖㔗垄垯噘京昽庯䫘 ALTER ROLE 麉变劉蓐謾㔗

埗昄

groupname

襕敘櫹䔇䂇(蓐謾)劉䓄

username

庖崺劏䂇(蓐謾)婺嵂媹潡傯䂇(蓐謾)婺役鍴䔇䫘潙劉(媙釂噾䂟庻婘)㔗ALTER GROUP 幽婉录傺潡役鍴䫘潙㔗

newname

䂇䔇桄劉庖

冋床

劏䂇婺嵂媹䫘潙

ALTER GROUP staff ADD USER karl, john;

傯䂇婺役鍴䫘潙

ALTER GROUP workers DROP USER beth;

噚垹攓

SQL 湺庖麯澇橬 ALTER GROUP 臺埖㔗

埽蓕

GRANT, REVOKE, ALTER ROLE
劯锔饡釕嬉誕
ALTER FUNCTION婪婔亓ALTER INDEX