Active Directory用户的MS Access权限 [英] MS Access permissions with Active Directory users

问题描述

是否可以使用Active Directory用户设置访问权限？

编辑：总体目标是允许某些用户查看某些表并拒绝其他用户的此权限。我想知道是否可以使用活动目录用户来完成。

Is it possible to set Access persmissions using Active Directory users?
Edit: The overall objective is to allow some users to see certain tables and deny this permission for other users. I'm wondering if it can be done using active directory users.

推荐答案

取决于您对访问权限的理解。访问用户级别的安全性不会以任何方式与Active Directory交互。 ACC：下载中心中提供的Microsoft Access安全常见问题解答建议您多次重读此常见问题解答。我必须承认我从未完全理解它。另请参见 ACC2000：如何保护Microsoft Access数据库概述

Depends on what you mean by Access permissions. Access user level security do not interact with Active Directory in any way. ACC: Microsoft Access Security FAQ Available in Download Center It is suggested you reread this FAQ several times. I must admit I never quite understood it. Also see ACC2000: Overview of How to Secure a Microsoft Access Database

现在您可以做的是读取已登录用户和组等的Active Directory数据。然后，使用一些本地表将各种AD组以及登录用户ID映射到Access中的各种对象和菜单项，您就可以用这种方式控制访问。但是请注意，本地表可能会被精明的用户等破坏。

Now what you could do is read the Active Directory data for the logged in user and groups and such. Then with some local tables mapping the various AD groups along with the login userid to the various objects and menu items in Access you could control access in this fashion. Note however that local tables can possibly be mucked with by a savvy user, etc, etc.

我发现最有用的URL是以下新闻组发布的需要使用VB选项获取W2K广告域（fqdn）列表的帮助在处理此主题时，我保留了一页笔记，但它们可能有用也可能没有用。我可以根据需要发布它们。

The most useful URL I found was the following newsgroup posting need help on get list of W2K ad Domain (fqdn) by using VB Options I kept a page of notes when I was working on this topic but they may or may not be useful. I can post them if desired.

这篇关于Active Directory用户的MS Access权限的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！