sqldelphims-accesspermissionsdbtable

Table access permission restriction in MS Access

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

Solution

  • 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