<div>
Regarding credentials, since both are Microsoft, you can use windows authentication to pass credentials so long as you set the user with Execute privilege on SQL server. This way credentials will not be seen.
</div>


Regarding credentials, since both are Microsoft, you can use windows authentication to pass credentials so long as you set the user with Execute privilege on SQL server. This way credentials will not be seen.

<div>
<div class="content wysiwyg-content">
Is it possible to setup a user on SQL Server 2008 that can <b>ONLY </b> create records (via ADO/SQL from a client app. In my case Excel VBA) but <b><i>not </i></b>connect with SQL Server Management Studio?<br />
<br />
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.<br />
<br />
Thanks
</div>
</div>


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.

Thanks

SQL Server 2008 - restrict user access

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.