Here is the scenario:
Company A would want to share his data with Company B. He only wants to share a view from his database. Currently, Co. A gave a public access to Co. B.
Co.A doesn't want that Co.B to look through the logic of the stored procedures, the tables structures ...plain and...
How can I configure SQL Server in such a way that the a given user can only "execute(select)" a view without letting him see,execute,read etc... on any object in any database on the server?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.