View Full Version : Stored Procedures in MSSQL
Tom D'Souza
January 8th 04, 01:24 AM
In MSSQL, how can one grant execute permissions (at the admin level) for stored precedures like xp_sendmail, xp_stopmail etc...to other users?
James Hokes
January 8th 04, 01:26 AM
Tom,
If you want to use EM, look in 'master' under 'Extended Stored Procedures'
For ISQLW, look at BOL for GRANT.
James Hokes
"Tom D'Souza" > wrote in message
...
> In MSSQL, how can one grant execute permissions (at the admin level) for
stored precedures like xp_sendmail, xp_stopmail etc...to other users?
Cindy M -WordMVP-
January 8th 04, 01:27 AM
Hi =?Utf-8?B?VG9tIEQnU291emE=?=,
Please remove the public.word.newusers group from any follow-ups to this message. It has absolutely nothing to do with MSWord...
> In MSSQL, how can one grant execute permissions (at the admin level) for stored precedures like xp_sendmail, xp_stopmail etc...to other users?
>
Cindy Meister
vBulletin® v3.6.4, Copyright ©2000-2012, Jelsoft Enterprises Ltd.