Copy and paste security permissions from copies of a db (1 Viewer)

[Erin Cimbrie]

I have to make a new copy of a db starting with a blank db and importing all the objects into the blank. (Corruptions issues).

When a blank db is made, and the objects imported into it, the security permissions do not copy over. The only way I know how to get the security permissions back is to redo them in the new copy. It's a big db. Lots of time. Ugh.

Is there any way to copy and paste the security permissions from one db to another?

Thanks

 

[freakazeud]

re:

Hi,
I think the permission information is actually stored within the mdb file so importing everything into a new application will get rid of them and you would need to reapply them manually. There is a utility here which promises the following:

DbUtilities 1.0
Utilities to copy permissions from an existing database and then reapply the permissions to a new database with the same structure. Useful when a new database must be created by importing objects into a new database.

I've not worked with this so I cannot promise anything.
HTH
Good luck