We would like to introduce an external orchestrator in order to feed some tables from two stored procedures on SQL Server. However, we will need to create an 'orchstr' user for the orchestrator. We want to give access to the user 'orchstr' to execute only the two specified stored procedures (so there is a restriction on the other procedures). And access on the tables to be fed only.
Is it possible? How could we do this?
I'm still a beginner, it would be too kind of you to help me.
We have SQL Server 2012 Enterprise Edition.