SQL Server 2008 restricted user access
Posted on 2013-05-27
I have a working database but have had request to provide access for a third party application.
I have created a series of SPs to do this, but now I would like to create a user, VhcUser, which can only execute SPs and can only "see" the ones for the application. I would then build a connectionstring with these credentials and give it to the third party.
I believe that the best way to do this woul be to use SQL Server authentication, but I have never done aniything like this before.
Can anyone help?