I have to set an old AD user to a new ad user.
The old AD user has many access rights on several databases, tables, roles ....whatever.
I must create a new user, already set in the AD and give them the same rights back, as the old AD account had.
I made this manually, but I have a lot of trouble with this doing/thinking.
If I thought, I have all set, then I found on access from the application, used by a DSN ODVC resource from another system, that I have overseen alter rights in tables or no access on functions and so on.
How I can get all old permissions, settings from several databases from one user - to keep this settings to the same database on the new AD user account?
the permissions are not set on the AD for the users.