CREATE ROLE testrole NOCREATEDB NOCREATEROLE NOCREATEUSER NOINHERIT NOLOGIN ENCRYPTED PASSWORD 'XXXX';

CREATE USER test1 INHERIT ENCRYPTED PASSWORD 'prueba2';

GRANT testrole TO test1 ;

GRANT SELECT ON customer TO testrole;