Is it possible to setup a user on SQL Server 2008 that can ONLY create records (via ADO/SQL from a client app. In my case Excel VBA) but not connect with SQL Server Management Studio?
Background: I'm creating an Excel VBA demo (that INSERTs records into a table) for open distribution. The connection string will be visible. I don't want anyone with those login credentials to be able to connect to the database and look inside.