4
I made a View
to send to a customer, but I can’t pass the login and password to the general access. This way I created a user (cliente_view
) and I would like this to view only the created View (View_consult_vendas).
- How to do this process above?
Gabriel, I found this question on Database Administrators. Ai says that you must grant access to this user. Maybe the question can be useful to you, if you can put the result to us in the answer :)
– Marconi
On your user, run the command that gives permission:
GRANT SELECT ON dbo.MyViewName TO username;
– Don't Panic
You can create the user, assign no group, and give access only to
view
using the command:GRANT SELECT ON View_consulta_vendas TO cliente_view
– Ricardo Pontual
Marconi, Everson and Ricardo. First thank you for your attention. USE SISTEMA_CLIENTE CREATE USER cliente_view for login cliente_view GRANT SELECT ON view_consulta_vendas_client TO cliente_view
– GabrielDragone