How to create SQL Security Group for ODBC
Posted on 2009-05-06
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!