Hello Robbert, hello John,

thanks for these informations. I think now I get it.

Together with my SystemAdmin I have solved the

sp_xp_cmdshell_proxy_account issue, and now

I can give the users xp_cmdshell...

Hi Adi,

thanks very much for this detailed and very useful information. Now I get it. I think your post will be helpful for many other visitors of this forum,...

Hi Adi,

thanks very much. This was the solution. When I just do:

GRANT SELECT ON [dbo].[vw_my_view] TO [db_viewer_role]

without DENYING the other permissions, I get exactly what I need.

A SELECT works...