You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
18 lines
581 B
18 lines
581 B
-- Berechtigungen
|
|
|
|
CREATE ROLE sekretariat;
|
|
CREATE ROLE schatzmeisterei;
|
|
CREATE ROLE presse;
|
|
|
|
-- Sekretariat (Generalsekretär)
|
|
GRANT SELECT, INSERT, UPDATE, DELETE ON pmv.mitglied TO sekretariat;
|
|
GRANT SELECT, INSERT, UPDATE, DELETE ON pmv.beitrag TO sekretariat;
|
|
GRANT SELECT, INSERT, UPDATE, DELETE ON pmv.wahl TO sekretariat;
|
|
GRANT SELECT, INSERT, UPDATE, DELETE ON pmv.wahlkreis TO sekretariat;
|
|
|
|
-- Schatzmeisterei
|
|
GRANT SELECT, INSERT, UPDATE ON pmv.buchung TO schatzmeisterei;
|
|
|
|
-- Presse
|
|
-- TODO Felder über einen View einschränken
|
|
GRANT SELECT ON pmv.mitglied TO presse;
|
|
|