Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2000-12-18 : 20:04:19
|
Greg writes "To use XP_SENDMAIL a user needs to be granted execute access to the XP_SENDMAIL extended stored procedure in the MASTER DB. To do this we have set up a role in the master database called "mail" and put a number of users in the roles. The only thing this role can do is execute the "XP_SENDMAIL" extended stored procedures. Today there is only a handful of users in this role.
Now seems that the MASTER database should be basically not altered from the basic installation. Plus if we start having lots of need for applications to send mail via XP_SENDMAIL then this method of granting execute permissions might not be the best solution.
Are there other was to allow individuals access to XP_SENDMAIL without altering MASTER? Are the issues with to many individuals having access to XP_SENDMAIL? Any suggestions. How have others set this up.
SQL SERVER: 7.0 SP1 Windows NT: 4.0" |
|
|
|
|
|
XP_SENDMAIL