By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 1,021 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

User- and Workgroup Permission Problem

P: 44
I have a really weird issue with the security of my database.
I set up a workgroup and some usergroups and users. I have a an admin usergroup, a read-only usergroup and a project-manager usergroup. In each usergroup I have several user.
No I give the user in the project-manager usergroup a different permission to tables and queries than an user in the read-only usergroup.
What happens now is very strange and if I would not be sure it can't be I would say somebody else is manipulating my security permissions.
Because when I logon as an user from the project-manager usergroup I got access refusals to queries I permitted a minute before. Also when I exit the database and logon after that as a read-only user I have the same access refusals than the other user before. When I logon as admin user and check all the permissions I see that they have changed like magic. I permit again the correct access for all user. Doublecheck it and test it again. This time starting with the read-only user - everything fine. Go ahaed with the project-manager user - access refusal. Try again the read-only user. Suddenly problem there as well.
I can't understand how the different usergroups are connected to depend on the permission, though this is something which can be change by the admin user only?

Does anybody had the same experience ? Or an idea how I can get rid of this issue?

Thanks very much...
Oct 10 '06 #1
Share this Question
Share on Google+
1 Reply

Expert 100+
P: 1,418

I think that the engine for users, user groups and permissions is very annoying.. You never know if you have assigned a permission to sby!

When you assign permissions, can you verify that they are assigned really?

In fact I don't use the system of security used by Access.. And i create my own.... And it works perfect... Coz the Access security is very poor... Everybody can enter there that is more experienced with Access - without passwords! :) ;) :)

Best regards!
Oct 14 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.