import security definitions

[Mag. Andreas Wöckl]

Hi Group!

I have the following problem: I had to define very complex security
permissions on various groups for an access database. I forgot to take away
the permissions and the ownership of the administrator - so it it still
possible to open the mdb directly. So If I Import the objects to a new
database - I do not have the permissions that I have set!

Is there a chance to migrate the permissions - it was a lot of work!

best regards

andy

 

['69 Camaro]

Hi, Andy.

Is there a chance to migrate the permissions - it was a lot of work!

Use Access MVP's Sandra Daigle's and Jeff Conrad's DBUtilities utility to
copy the permissions from the old database to the new database.

http://www.daiglenet.com/MSAccess.htm

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact
info.

 

[Mag. Andreas Wöckl]

Hi Gunny!

Many thanks - that's the solution!

have a nice weekend!

cu

andy

 

[Mag. Andreas Wöckl]

Hi Guny!

I still have a litte problem:

DB1 is owned by Administrator (I have to take the permissions of this
database)
DB2 is owned by user "xy" - I imported all objects of DB1 to it

Now I want to transfer the security permissions - If I open DB1 as
administrator and try to transfer - I get an error message that I do not
have permissions on DB2 - If i open DB2 with my workgroup file and user "xy"
I get the message that I do not have permissions to DB1.

That seems to be an issue of ownership - do you know a workaround?

Andy

 

[Joan Wild]

I would use Sandra's code to do this. Open DB1 and run the code to copy the
permissions to a table.

Open DB2 as new owner, import all the objects. Open the permissions table
and change 'Administrator' to 'xy'.

Then use the code to load the permissions.

 

[Mag. Andreas Wöckl]

Hi Joan!

If I use the Access ADD-In I can only select a source and a target DB - I
can not select a table to copy the permissions to..

How can I use the code without the wizard?

Thanks in advance

andy

 

[Joan Wild]

Don't use the addin; use Sandra's code that the addin was based on.

DBUtilities 1.0 part way down this page:
http://www.daiglenet.com/MSAccess.htm

 

[Andreas Wöckl]

Hi Joan - many thanks for the info!

Don't use the addin; use Sandra's code that the addin was based on.

DBUtilities 1.0 part way down this page:
http://www.daiglenet.com/MSAccess.htm