Is it possible to allow a stored procedure to be called only from a particular application or from an application running from a specific location?
Posted on 2012-03-14
I have a database on a MSSQL 2008 server that has several stored procedures. The only way of interacting with the data in the tables is through those stored procedures. Is there any way to restrict access to the stored procedures to applications that run from a particular location - i.e. a specific network share? A large number of users need access to the data, but we would like to tightly control how they access it.