Ok, this one is driving me crazy. All I've done is create two security groups on top of the Admin and Users groups, and added some users to each. I set permissions to tables, etc according to the group, not particular users. But at inconsistent times, when I'm logging in as different users, just to test the access of groups, the permissions for objects seem to change. At one time I will log in as a user and see data from tables that I have set appropriately(through the Security menu). Then I'll log on again as that user and be told that I don't have permissions to what I previously did.
I'm the only one that has access to this database to make security changes. I access this database using a shortcut that uses the right mdw file (not system.mdw).
I've gone back and forth, resetting permissions over and over again. Any help please!!