Providing access to the SQL server database for outside developers
Not quite sure what exactly your question is. However, let me try an answer...

In general it is a good idea to have all application access go exclusively through a layer of views and procedures. That allows to run multi step migrations under the covers without impacting the running application. Through that you can implement changes like moving a column of a 2 TB table to another table without downtime.

It is also a good practice to restrict application access to only the minimum required level. So giving the app read/write access to just the views and procedures is a good idea.

Finally, any web developer should know how to use a connection string. So if that is your question, you are good there too.

If you were going for something else, leave a comment below.