====== Foods (Mobile) ======

===== Criação do usuário Mobile =====

Criar usuário ''mobile'' com senha ''masterkey''.

Abra o IBExpert e execute o seguinte script:

<code .sql>
CREATE USER MOBILE PASSWORD '1234';
</code>

===== Permissões do usuário Mobile =====

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

<code .sql>
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;
</code>

Obs: Os Comissionados na retaguarda devem ter nomes distintos.