<div>
In SQL Server; You could create a role in your database and assign permissions of the role to a specific group in AD. <br />
<br />
Just set your ODBC connection on each machine to use Integrated Authentication and that should sort you out.<br />
<br />
HTH
</div>


In SQL Server; You could create a role in your database and assign permissions of the role to a specific group in AD.

Just set your ODBC connection on each machine to use Integrated Authentication and that should sort you out.

HTH

<div>
Hi,<br />
<br />
Thanks, but where in SQL Server to I create the role?<br />
<br />
Thanks,<br />
Jason
</div>


Hi,

Thanks, but where in SQL Server to I create the role?

Thanks,
Jason

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I would like to set up a security group that allows a network user access to certain SQL tables of a database via SQL Server Datasource in ODBC. <br />
<br />
This is the scenario, we have a SQL database that certain documents like excel and access dbs access the tables of to query information. There are different SQL Securty Groups defined in Active Directory that specify which tables are accessbile to included group members. Each user has the system or user SQL data source set up in ODBC and is added to the necessary group in AD. I can create the group in AD no problem, I'm just not sure where to define what SQL tables the groups have access to, on the SQL Server, if so where?<br />
<br />
Thanks in advanced for the help!<br />
<br />
Jason
</div>
</div>


Hello,

I would like to set up a security group that allows a network user access to certain SQL tables of a database via SQL Server Datasource in ODBC. 

This is the scenario, we have a SQL database that certain documents like excel and access dbs access the tables of to query information. There are different SQL Securty Groups defined in Active Directory that specify which tables are accessbile to included group members. Each user has the system or user SQL data source set up in ODBC and is added to the necessary group in AD. I can create the group in AD no problem, I'm just not sure where to define what SQL tables the groups have access to, on the SQL Server, if so where?

Thanks in advanced for the help!

Jason

How to create SQL Security Group for ODBC

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.