CREATE SCHEMA alok_schema;
CREATE ROLE alok LOGIN PASSWORD 'alok';
GRANT USAGE ON SCHEMA alok_schema TO alok;
CREATE MATERIALIZED VIEW alok_schema.mview_alok as SELECT name, location from sometable;
GRANT SELECT ON alok_schema.mview_alok TO alok;

REVOKE ALL PRIVILEGES ON SCHEMA public FROM PUBLIC;
REVOKE ALL PRIVILEGES ON SCHEMA public FROM alok;

psql -h localhost -U alok db_name