Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 418
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

A proven path to a career in data science

At Springboard, we know how to get you a job in data science. With Springboard’s Data Science Career Track, you’ll master data science  with a curriculum built by industry experts. You’ll work on real projects, and get 1-on-1 mentorship from a data scientist.

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