Copy Authorizations from one DB to an other

[Former Member]

I am trying to copy authorizations from one DB to an other. I have 10 databases and the users work in all 10, in order to save some time, I would like to do the mods in one and copy to the other.

I know I could use copy express, but in this case I can not because it creates problems with the add-on that we are running and it takes an enormous amount of time to copy from/to.

Any suggestions ?

Thanks,

Sophie

[former_member583013 · Accepted solution]

By far Copy Express is what is used for this. But if you do not prefer to use it then the other option is to manually set authorization for the one template user and drag and drop them over.

Perhaps you are aware of this but there I do not think there is a 3rd way to this.

Suda

[Former Member]

Hi Sophie,

Unfortunately, the user authorization table is hidden from users.

You can copy user authorization only when you copy complete database or using Copy Express.

Thanks,

Gordon