DROP VIEW pracoviste;
DROP VIEW zamestnanci;
DROP VIEW mzdy;

CREATE VIEW pracoviste  AS SELECT * FROM sqltutor.pracoviste; 
CREATE VIEW zamestnanci AS SELECT * FROM sqltutor.zamestnanci;
CREATE VIEW mzdy        AS SELECT * FROM sqltutor.mzdy;

REVOKE ALL   ON pracoviste  FROM public;
REVOKE ALL   ON zamestnanci FROM public;
REVOKE ALL   ON mzdy        FROM public;

GRANT SELECT ON pracoviste  TO public;
GRANT SELECT ON zamestnanci TO public;
GRANT SELECT ON mzdy        TO public;
