criar view read only - mysql

[José Luiz Siesler Jr 0]

Bom dia pessoal

 

Descobri que as views do mysql são criadas por default como updatable, no entanto, preciso que minhas views sejam read only.

 

CREATE or REPLACE VIEW teste.fat_pendente_faturamento_vw AS 
select cte.remetente AS cliente,
	   cte.id_importacao AS cte,
	   cte.empresa AS empresa,
	   vlr.valor_total AS valor_cte 
from (teste.fat_imp_cte cte join teste.fat_imp_cte_valor_prest vlr) 
where ((cte.id_importacao = vlr.id_cte) and 
      isnull(cte.id_fatura) and 
      (cte.tomador_servico = 0)) 
union 
select cte.destinatario AS cliente,
       cte.id_importacao AS cte,cte.empresa AS empresa,
       vlr.valor_total AS valor_cte 
from (teste.fat_imp_cte cte join teste.fat_imp_cte_valor_prest vlr) 
where ((cte.id_importacao = vlr.id_cte) and 
      isnull(cte.id_fatura) and 
      (cte.tomador_servico = 3)) 
order by cliente,cte
whith read only;

recebo o seguinte erro:

ERROR: You have an error in your SQL syntax; check the manual
that corresponds to your MySQL server version for the right
syntax to use near 'whith read only' at line 19
Error Code:
1064

conseguem ajudar?

[Motta 645]

http://dev.mysql.com/doc/refman/5.0/en/view-updatability.html