使用 SQL 的 MS Access 用户权限 [英] MS Access user permissions using SQL

问题描述

是否可以像下面这样在 Access 中使用 SQL 添加对多个对象的权限?

Is it possible to add permissions on multiple objects using SQL in Access like below?

GRANT SELECT, DELETE, INSERT, UPDATE, DROP, SELECTSECURITY, UPDATESECURITY, UPDATEIDENTITY, CREATE
ON PERSON, INVOICE, CUSTOMER, EMPLOYEE
TO Developers

推荐答案

DDL GRANT 和 REVOKE 语句似乎在特定版本的 MS Access 中可用.

The DDL GRANT and REVOKE statements seem to be available in specific versions of MS Access.

Access 2007，如此处所述:http://msdn.microsoft.com/en-us/library/office/bb177904(v=office.12).aspx

Access 2007, as documented here: http://msdn.microsoft.com/en-us/library/office/bb177904(v=office.12).aspx

Access 2013，如此处所述:http://msdn.microsoft.com/en-us/library/office/ff193820(v=office.15).aspx

Access 2013, as documented here: http://msdn.microsoft.com/en-us/library/office/ff193820(v=office.15).aspx

该功能并不总是存在.MS-Jet 4.0 引擎(由 Access 2000 使用)有它们......但我找不到关于它首次出现在哪个版本的 Access/MS-Jet 的文档.

The feature was not always there though. The MS-Jet 4.0 Engine (used by Access 2000) had them... but I can't find documentation on which version of Access/MS-Jet it first appeared in.

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