How can I copy a user group?

  • Thread starter Thread starter Paul Harrold
  • Start date Start date
P

Paul Harrold

I have a quite complex DB. I need to create 8 different user groups, for my
16 users. Creating groups will be extremely time consuming due to the amount
of tables/queries etc.. in the database.

Now I know most people would recommend I create several groups and assign
each user to more than one group to give them their desired permissions. OK
that makes sense, but it will be harder to manage when objects are added to
the DB or security requirements change. So I would much rather work with 8
distinct though similar groups, so that I will not need to concern myself
with the "knock on" effects of changing permissions in one particular group.

So can anyone tell me how to copy a user group?

I have scoured the web and the NGs and can't find any info on this!

Thanks,

Paul
 
Many thanks Joan,

I am a little confused by this code as it only grabbed permission info from
the "Admins" and "Users" groups. Here is what I did:

I used previously secured database and added the "Admin" user back in to the
"Users" group so that the code could access this DB without error. I
imported the "$tblPermissions" to this database and ran the
"DumpPermissions" procedure. The output to the "DumpPermissions" table only
contained info on the "Admins" and "Users" groups, even though several other
groups have permissions set on the databases objects.

What did I miss?

Thanks,

Paul

P.S i am using Access 2000 :O)
 
Joan,

I finally got it to work, what a lovely bit of code! Is it your own?

Either way, many thanks for your help, you have saved me a lot of time and
anguish :O)

Regards,

Paul
 
Back
Top