Monday, March 19, 2012

A table owner to use xp_sendmail

how can i open the rights if
a table owner (not system administrator) to use xp_sendmail
Thanks a lot.
tonyCreate a user for that login in the master database and grant execute rights for that user in the
master database to xp_sendmail.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Tony WONG" <x34@.hknet.com> wrote in message news:OzaaNJ4hGHA.1508@.TK2MSFTNGP04.phx.gbl...
> how can i open the rights if
> a table owner (not system administrator) to use xp_sendmail
> Thanks a lot.
> tony
>

No comments:

Post a Comment