DROP VIEW toky;
DROP VIEW stanice;
DROP VIEW vodocty;
DROP VIEW limity_cm;
DROP VIEW cleneni;

CREATE VIEW toky      AS SELECT * FROM sqltutor.toky; 
CREATE VIEW stanice   AS SELECT * FROM sqltutor.stanice;
CREATE VIEW vodocty   AS SELECT * FROM sqltutor.vodocty;
CREATE VIEW limity_cm AS SELECT * FROM sqltutor.limity_cm;
CREATE VIEW cleneni   AS SELECT * FROM sqltutor.cleneni;

REVOKE ALL   ON toky      FROM public;
REVOKE ALL   ON stanice   FROM public;
REVOKE ALL   ON vodocty   FROM public;
REVOKE ALL   ON limity_cm FROM public;
REVOKE ALL   ON cleneni   FROM public;

GRANT SELECT ON toky      TO public;
GRANT SELECT ON stanice   TO public;
GRANT SELECT ON vodocty   TO public;
GRANT SELECT ON limity_cm TO public;
GRANT SELECT ON cleneni   TO public;
