in sql 2000 u can use set user, and sql 2005 u can use as user, see on the
books on line there u can find help about ?

regards.
"Sam" <focus10@zahav.net.il> escreveu na mensagem
news:uKzCpepRGHA.4332@TK2MSFTNGP10.phx.gbl...
[quoted text, click to view]

how i grant to user who has no write permission a temporary permission for
a writtnig job
like add a new user?

thanks