I have a problem with permission issue.
I have added a group and set its permission to grant SELECT, deny INSERT/UPDATE/DELETE.
However, there are users in this group that is supposed to have grant permission for SELECT/INSERT/UPDATE/DELETE.
Is there an alternative way besides adding each user ID in the server?
FYI, user ID are from Active Directory (windows login authentication).