Permissions not working, leaving my DB Wide Open

[John JAB]

Hello,
I have recently set up a database and then secured it
using the user level security wizard. It appeared it was
working great at first. I have the DB in a shared
folder. I have it password protected. This all works
correctly, someone must join my secured workgroup and have
a password.

here is the problem. I set all kinds of permissions as
the administrator for people to only have access to
certain forms, reports, etc. But, when they log in, they
have full permissions and controls.

I repeat, I set up a unique workgroup information file so
I wouldn't have this problem. Is there some kind od
toggle I have to switch on the security with? After
setting permissions and applying, is there another step.

Thanks,

John

 

[Rick Brandt]

Hello,
I have recently set up a database and then secured it
using the user level security wizard. It appeared it was
working great at first. I have the DB in a shared
folder. I have it password protected. This all works
correctly, someone must join my secured workgroup and have
a password.

here is the problem. I set all kinds of permissions as
the administrator for people to only have access to
certain forms, reports, etc. But, when they log in, they
have full permissions and controls.

I repeat, I set up a unique workgroup information file so
I wouldn't have this problem. Is there some kind od
toggle I have to switch on the security with? After
setting permissions and applying, is there another step.

Users get permissions that are explicitly set for their UserName AND they
get permissions by virtue of being members of Groups. If you see Users are
able to do things that their individual permissions would indicate they
shouldn't, then they must be getting those rights because of their Group
memberships.

Many recommend ONLY giving permissions to groups and never to individuals
as this is much easier to maintain.