grant.sql

GRANT SELECT
on ferienwohnung
TO dbsys42;

GRANT SELECT
on land
TO dbsys42;

GRANT SELECT
on ausstattung
TO dbsys42;

GRANT SELECT
on touristenattraktion
TO dbsys42;

GRANT SELECT, INSERT
on adresse 
TO dbsys42;

GRANT SELECT, INSERT, DELETE
on kunde
TO dbsys42;

GRANT SELECT
on bilder
TO dbsys42;

GRANT SELECT
on besitzt
TO dbsys42;

GRANT SELECT
on in_der_naehe_von
TO dbsys42;

GRANT SELECT, INSERT, DELETE
on buchung
TO dbsys42;

GRANT SELECT, INSERT
on anzahlung
TO dbsys42;

GRANT SELECT
ON buchungsnr
TO dbsys42;