How to make a user in SQL Server 2008 see only one VIEW?

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 .

Scroll to Top
AllEscort