Table access permission restriction in MS Access

Question

How can I restrict the access of a table just for one specific db user in MS Access by SQL DDL statemets?

Answer 1

Use Grant and Revoke statements

REVOKE {privilege[, privilege, …]} ON {TABLE table | OBJECT object|

CONTAINTER container} FROM {authorizationname[, authorizationname, …]}

Syntax

GRANT {privilege[, privilege, …]} ON {TABLE table | OBJECT object|

CONTAINER container } TO {authorizationname[, authorizationname, …]}

see more: https://msdn.microsoft.com/en-us/library/bb177904%28v=office.12%29.aspx