-- user grants for RobtestDB

-- Users are: mercadeo,vallero,rusanov,robocop,operator and guest
-- Create users like this with psql:
--  CREATE USER robocop ENCRYPTED PASSWORD '--here the password--';
-- Use: psql robtestproduction -s -f grants4robtestdb.sql 

GRANT select,insert,update ON boardtests TO robocop;
GRANT select,insert ON allboards,deliverynote,inventur TO operator;
GRANT select ON boardtests,errors TO operator;
GRANT select,insert,update ON allboards,deliverynote,boardtests,errors,inventur TO rusanov,mercado,vallero,janson;
GRANT select ON allboards,deliverynote,boardtests,errors TO guest;
