I have a server A and in that i have 10 databases a1,a2,a3....a10.I have created an username xxxx and i wanted to give all DML permissions on all the 10 databases on this server A.How to do that..
You either have to put them in the right db role in each db, or put them in a higher level server role that would give them the permissions in all dbs, not just the ones you specified here.