I made a
View to send to a client, but I can't pass the login and general access password to the same. In this way I created a user (
cliente_view ) and I would like it to view only the View created (View_consulta_vendas).
- How to do this process above?
You need to give this user who created (
cliente_view ) the privilege you want, in your case, to give access only to
SELECT permission, use
GRANT SELECT ON view_consulta_vendas TO cliente_view;
Note: as you already created the user, check which permissions he already has, if you want to remove any, use