create view view_TabelaCliente with schemabinding --nao dexa apagar a tabela as select cli.Nome ,cli.Cpf,cli.CpfFormatado,cli.Sexo from dbo.Cliente cli where cli.Sexo = 'f' with check option --grant select on view view_TabelaCliente to usuario --deny insert,update on view view_TabelaCliente to usuario update view_TabelaCliente set Nome ='Maria Joaninha' where Sexo = 'f' select * from view_TabelaCliente