Question:
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?
Answer:
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 :
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 REVOKE .