472,143 Members | 1,143 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,143 software developers and data experts.

Use active directory to control the access to .mdb file

I am thinking about linking Oracle database to Access database but
want to use Active Directory to control the access to mdb. Is this
acheiveable? How?

Oct 26 '07 #1
1 2191
On your server create/add a user group (standard management area for
win2003 server, Administrative Tools or Security I think for win2000
server). You have to manually add the userNames to that group -- that I
know of. Maybe that can be automated like read from an Excel file.

On the Sql Server go to the Security section for that server and add the
group. The check off which databases this list of users has access to
in the Database Access tab. In the lower window of the Database Access
tab select public and the scroll down and select datareader. This will
give ReadOnly rights to the databases selected for each member of this
group. If any of the members need more access like write access, then
you can create another group on the server computer with the respective
special users and add this new group to the security section of the Sql
Server and then add the databases they need access too and the type of
access that they need.

You don't need to worry about server roles at this point.


*** Sent via Developersdex http://www.developersdex.com ***
Oct 26 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Andrew | last post: by
2 posts views Thread by Jim in Arizona | last post: by
7 posts views Thread by Vio | last post: by
reply views Thread by leo001 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.