Group permission removed everytime user-level security wizard run

[JenSGT]

I created 3 Groups, Primary, Secondary & Tertiary with different permissions. The permissions are set at the group level.
Everytime, I use the security wizard to add a new user and re-run the security on the new objects, the created groups permissions will be completely remove and the created group will have no permission on all the objects.

Why such a strange behavior?

I'm forced to recreate the permissions everytime this happens.

How can I permanently set the group permissions?

TIA, any help appreciated..

 

[JohnLee]

Hi,

When I am setting up security in Access I do the following:

Select Tools\Security\User and Group Accounts.

I select the tab "Group Accounts", click the button "New" and enter the name of the group I want to create.

I then select the tab "Users", under the area "User" I click on the "New" button and create the various users.

Under "Group Membership" I add the user to the newly created group or the desired group listed under the "Available Groups" list. After adding them to the desired group, I then click ok and then do the following:

Select Tools\Security\User and Group Permissions, I make sure the "Permissions" tab is selected and click on the groups radial. All the available groups will appear, select the desired group and then select from the Object Type drop down list i.e. tables, quries etc. then under the object name select all the objects you want to set security restrictions on for this group and then from the "Permissions" radials select the type of permission you want for that group for those highlighted objects. click the "OK" button and do the same again for each object type in the object drop down list for each of the groups, clicking the OK button after each operation.

Once you have done this all those users that belong to their respective groups will only have permission to access only those object you have set for them.

Hope this helps.

FAB

John

 

[JohnLee]

Hi,

When I am setting up security in Access I do the following:

Select Tools\Security\User and Group Accounts.

I select the tab "Group Accounts", click the button "New" and enter the name of the group I want to create.

I then select the tab "Users", under the area "User" I click on the "New" button and create the various users.

Under "Group Membership" I add the user to the newly created group or the desired group listed under the "Available Groups" list. After adding them to the desired group, I then click ok and then do the following:

Select Tools\Security\User and Group Permissions, I make sure the "Permissions" tab is selected and click on the groups radial. All the available groups will appear, select the desired group and then select from the Object Type drop down list i.e. tables, quries etc. then under the object name select all the objects you want to set security restrictions on for this group and then from the "Permissions" radials select the type of permission you want for that group for those highlighted objects. click the "OK" button and do the same again for each object type in the object drop down list for each of the groups, clicking the OK button after each operation.

Once you have done this all those users that belong to their respective groups will only have permission to access only those object you have set for them.

Hope this helps.

P.S.

Oh in order for the security to work though you will need to create a workgroup using the User_Level Security Wizard. Ensure that you have a backup of your database before you do this,because once you've gone through that part of the security, there's no going back, also be careful to ensure that you have full administrative access on your user access. otherwise you will regret it.

FAB

John

 

[JohnLee]

Hi,

When I am setting up security in Access I do the following:

Select Tools\Security\User and Group Accounts.

I select the tab "Group Accounts", click the button "New" and enter the name of the group I want to create.

I then select the tab "Users", under the area "User" I click on the "New" button and create the various users.

Under "Group Membership" I add the user to the newly created group or the desired group listed under the "Available Groups" list. After adding them to the desired group, I then click ok and then do the following:

Select Tools\Security\User and Group Permissions, I make sure the "Permissions" tab is selected and click on the groups radial. All the available groups will appear, select the desired group and then select from the Object Type drop down list i.e. tables, quries etc. then under the object name select all the objects you want to set security restrictions on for this group and then from the "Permissions" radials select the type of permission you want for that group for those highlighted objects. click the "OK" button and do the same again for each object type in the object drop down list for each of the groups, clicking the OK button after each operation.

Once you have done this all those users that belong to their respective groups will only have permission to access only those object you have set for them.

Hope this helps.

P.S.

Oh in order for the security to work though you will need to create a workgroup using the User_Level Security Wizard. Ensure that you have a backup of your database before you do this,because once you've gone through that part of the security, there's no going back, also be careful to ensure that you have full administrative access on your user access. otherwise you will regret it.

FAB

John

 

[boblarson]

Why such a strange behavior?

I'm forced to recreate the permissions everytime this happens.

How can I permanently set the group permissions?

You don't run the Security Wizard more than ONCE. It isn't necessary to use it, in fact it is what is causing your problem, to add a new user. To add a new user you simply open the database (as an admin user), go to TOOLS > SECURITY > USER AND GROUP ACCOUNTS and then add a new user with the NEW button. Then, you assign them to a group.

 

[JenSGT]

How do I ensure the new objects created after user-level security is run remain secured?

If I want to programmatically set the permissions for the groups, how do i do that ?


Thkq, any tips is appreciate.

 

[boblarson]

How do I ensure the new objects created after user-level security is run remain secured?

If I want to programmatically set the permissions for the groups, how do i do that ?

As for programmatically setting permissions, I don't have a clue because I've never needed to do it. You might search on that though (here and Google) to get some answers about that.

As for new objects - once you have run the wizard, anything you create in the database is within the secure area. If you want to set specific access to specific groups or people you need to go to TOOLS > SECURITY > USER AND GROUP PERMISSIONS. But you never run the wizard more than once on a database.

 

[JenSGT]

How about importing objects after the User-level security wizard is ran? Will the imported objects also be secure without running the User-level security wizard again?

 

[boblarson]

How about importing objects after the User-level security wizard is ran? Will the imported objects also be secure without running the User-level security wizard again?

Again - the database is already secured when you have run the wizard. If you want specific people, or groups, to access newly imported items, you can go into the TOOLS > SECURITY > USER AND GROUP PERMISSIONS to set the permissions on those objects. If the public has no permissions then those newly imported objects will not have public permissions.