Solved

How to create SQL Security Group for ODBC

Posted on 2009-05-06
3
409 Views
Last Modified: 2012-05-06
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
Comment
Question by:taborj
  • 2
3 Comments
 
LVL 13

Expert Comment

by:St3veMax
ID: 24323272
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
 

Author Comment

by:taborj
ID: 24327358
Hi,

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

Thanks,
Jason
0
 

Accepted Solution

by:
taborj earned 0 total points
ID: 24363973
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

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question