PDA

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

Google