Thanks for the reply.

I have used the selection "Be Made Using Login's Current Security Context", but it has no use.

i`ve found the way that a permitted user could view the...

So many thanks

as i`ve told the USERA can not be paticipate in linked server because of security reasons.

May be i have to use SSIS to solve the problem.