Foods (Mobile)

Criar usuário mobile com senha masterkey.

Abra o IBExpert e execute o seguinte script:

CREATE USER MOBILE PASSWORD '1234';

Para que o usuário mobile possa acessar as tabelas e views é necessário definir as permissões de acesso no firebird.

RANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON ESTGRUPOS TO USER MOBILE;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON ESTPRODUTOS TO USER MOBILE;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON TFdsMesaCartao TO USER MOBILE;
GRANT DELETE, INSERT, SELECT, UPDATE ON TESTCLASSE TO USER MOBILE;
GRANT DELETE, INSERT, SELECT, UPDATE ON TESTPRODUTO TO USER MOBILE;
GRANT DELETE, INSERT, SELECT, UPDATE ON TFDSMOVIMENTACAO TO USER MOBILE;
GRANT DELETE, INSERT, SELECT, UPDATE ON TFDSPRODUTOSCONSUMIDOS TO USER MOBILE;
GRANT DELETE, INSERT, SELECT, UPDATE ON TFDSADICIONALITEM TO USER MOBILE;
GRANT DELETE, INSERT, SELECT, UPDATE ON TGERPARAMETROS TO USER MOBILE;
GRANT DELETE, INSERT, SELECT, UPDATE ON TVDACOMISSIONADO TO USER MOBILE;
GRANT DELETE, INSERT, SELECT, UPDATE ON TFDSFILAIMPRESSAO TO USER MOBILE;
GRANT DELETE, INSERT, SELECT, UPDATE ON TFDSFICHA TO USER MOBILE;
GRANT DELETE, INSERT, SELECT, UPDATE ON TGERPESSOA TO USER MOBILE;
GRANT DELETE, INSERT, SELECT, UPDATE, REFERENCES ON VWPRODUTOS TO USER MOBILE;
GRANT SELECT ON TGerUsuario TO USER MOBILE;
GRANT SELECT, INSERT, UPDATE, DELETE ON TGerBloqueio TO USER MOBILE;
GRANT SELECT ON TEstSabor TO USER MOBILE;
GRANT SELECT ON TEstProdutoSabor TO USER MOBILE;
GRANT SELECT ON TEstSubGrupo TO USER MOBILE;
GRANT SELECT ON TEstClasse TO USER MOBILE;
GRANT SELECT ON TFdsComplemento TO USER MOBILE;

Obs: Os Comissionados na retaguarda devem ter nomes distintos.