Geek Answers Handbook

MS Access user permissions using SQL

Can I add permissions for multiple objects using SQL in Access, as shown below?

GRANT SELECT, DELETE, INSERT, UPDATE, DROP, SELECTSECURITY, UPDATESECURITY, UPDATEIDENTITY, CREATE ON PERSON, INVOICE, CUSTOMER, EMPLOYEE TO Developers
+1
sql ms-access
source share
1 answer

The DDL GRANT and REVOKE statements are apparently available in certain versions of MS Access.

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

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

However, the function was not always. The MS-Jet 4.0 Engine (used by Access 2000) had them ... but I can’t find the documentation on which version of Access / MS-Jet it first appeared.

+1
source share

More articles:


All Articles