Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 416
  • Last Modified:

How to create SQL Security Group for ODBC

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
0
taborj
Asked:
taborj
  • 2
1 Solution
 
St3veMaxCommented:
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
0
 
taborjAuthor Commented:
Hi,

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

Thanks,
Jason
0
 
taborjAuthor Commented:
Figured it out, go into the SQL Server, open the DB your interested in and under USERS you can set this up.
0

Featured Post

[Webinar On Demand] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now