import security definitions

  • Thread starter Thread starter =?iso-8859-1?Q?Mag._Andreas_W=F6ckl?=
  • Start date Start date
?

=?iso-8859-1?Q?Mag._Andreas_W=F6ckl?=

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
 
Hi, Andy.
Is there a chance to migrate the permissions - it was a lot of work!
Click to expand...

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.
 
Hi Gunny!

Many thanks - that's the solution!

have a nice weekend!

cu

andy
 
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
 
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.
 
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
 
Back
Top