ROLES

CREATE ROLE administradores
GRANT ROLE administradores TO USER rebeca
REVOKE ROLE administradores FROM USER rebeca
GRANT CREATETAB, BINDAPP, CONNECT ON DATABASE TO ROLE administradores
GRANT SELECT, INSERT, DELETE, UPDATE, REFERENCES ON TABLE trabajos TO ROLE administradores
GRANT SELECT ON TABLE trabajos TO ROLE clientes
GRANT SELECT, INSERT, DELETE, ON TABLE maquinas TO ROLE moderadores
REVOKE SELECT, UPDATE (apellido, nombre) ON TABLE conductores FROM ROLE moderadores
UPDATE DBM CFG USING AUTHENTICATION SERVER_ENCRYPT