Hi
Wonder if anyone can help. I am using a backup script to auto-backup multiple databases on the same account. I can't find a way to set up a one to many user relationship with the databases using DA so that the script can connect to each database in turn to perform the backup.
Clearly this should be perfectly possible but setting up a user on the first database precludes setting the same user on a second (user already exists) and I can't see a way of giving permissions on the second (or subsequent) databases to an existing user of the first.
Anyone know how to work around this one?
Cheers
Mark
Wonder if anyone can help. I am using a backup script to auto-backup multiple databases on the same account. I can't find a way to set up a one to many user relationship with the databases using DA so that the script can connect to each database in turn to perform the backup.
Clearly this should be perfectly possible but setting up a user on the first database precludes setting the same user on a second (user already exists) and I can't see a way of giving permissions on the second (or subsequent) databases to an existing user of the first.
Anyone know how to work around this one?
Cheers
Mark