REVOKE ALL ON fakultaet FROM PUBLIC;
GRANT SELECT ON fakultaet TO GROUP iam;
GRANT SELECT ON fakultaet TO hsa;

REVOKE ALL ON studiengang FROM PUBLIC;
GRANT SELECT ON studiengang TO GROUP iam;
GRANT SELECT ON studiengang TO hsa;

REVOKE ALL ON lehrender FROM PUBLIC;
GRANT SELECT ON lehrender TO GROUP iam;
GRANT SELECT ON lehrender TO hsa;

REVOKE ALL ON professor FROM PUBLIC;
GRANT SELECT ON professor TO GROUP iam;
GRANT SELECT ON professor TO hsa;

REVOKE ALL ON lehrveranstaltung FROM PUBLIC;
GRANT SELECT ON lehrveranstaltung TO GROUP iam;
GRANT SELECT ON lehrveranstaltung TO hsa;

REVOKE ALL ON amtbeschreibung FROM PUBLIC;
GRANT SELECT ON amtbeschreibung TO GROUP iam;
GRANT SELECT ON amtbeschreibung TO hsa;



REVOKE ALL ON amt_fk FROM PUBLIC;
GRANT SELECT ON amt_fk  TO GROUP iam;
GRANT SELECT ON amt_fk TO hsa;

REVOKE ALL ON amt_stg FROM PUBLIC;
GRANT SELECT ON amt_stg TO GROUP iam;
GRANT SELECT ON amt_stg TO hsa;

REVOKE ALL ON fk_beteiligt_stg FROM PUBLIC;
GRANT SELECT ON fk_beteiligt_stg TO GROUP iam;
GRANT SELECT ON fk_beteiligt_stg TO hsa;

REVOKE ALL ON lehr_zugeordnet_stg FROM PUBLIC;
GRANT SELECT ON lehr_zugeordnet_stg TO GROUP iam;
GRANT SELECT ON lehr_zugeordnet_stg TO hsa;

REVOKE ALL ON lehr_haelt_lv  FROM PUBLIC;
GRANT SELECT ON lehr_haelt_lv TO GROUP iam;
GRANT SELECT ON lehr_haelt_lv TO hsa;

REVOKE ALL ON stg_zugeordnet_lv FROM PUBLIC;
GRANT SELECT ON stg_zugeordnet_lv TO GROUP iam;
GRANT SELECT ON stg_zugeordnet_lv TO hsa;
