DROP VIEW dopravni_letadla;
DROP VIEW letecke_spolecnosti;
DROP VIEW letecke_flotily;

CREATE VIEW dopravni_letadla    AS SELECT * FROM sqltutor.dopravni_letadla; 
CREATE VIEW letecke_spolecnosti AS SELECT * FROM sqltutor.letecke_spolecnosti;
CREATE VIEW letecke_flotily     AS SELECT * FROM sqltutor.letecke_flotily;

REVOKE ALL   ON dopravni_letadla    FROM public;
REVOKE ALL   ON letecke_spolecnosti FROM public;
REVOKE ALL   ON letecke_flotily     FROM public;

GRANT SELECT ON dopravni_letadla    TO public;
GRANT SELECT ON letecke_spolecnosti TO public;
GRANT SELECT ON letecke_flotily     TO public;
