Re: xp_startmail: won't run as non sa user
From: Rodney Mullins (rodney_mullins_at_msn.com)
Date: 04/08/04
- Next message: Hugo Kornelis: "Re: Select top n query"
- Previous message: Brad M.: "SELECT DISTINCT Query returning duplicate results"
- In reply to: dougj: "xp_startmail: won't run as non sa user"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 8 Apr 2004 15:19:38 -0400
doubj,
you need to give permissions to other users..
Check the info from MSDN..
Execute permissions for xp_startmail default to members of the db_owner
fixed database role in the master database and members of the sysadmin fixed
server role, but can be granted to other users. However, for security
reasons, you should limit permissions for this stored procedure to members
of the sysadmin fixed server role.
"dougj" <anonymous@discussions.microsoft.com> wrote in message
news:2A9C9338-BA93-40BD-9AF8-22588F6A42DD@microsoft.com...
> I'm running an application that has a trigger including xp_startmail. It
runs under an sa account but doesn't when run with a normal user it seems.
Anybody have basic suggestions?
>
> Thanks
>
- Next message: Hugo Kornelis: "Re: Select top n query"
- Previous message: Brad M.: "SELECT DISTINCT Query returning duplicate results"
- In reply to: dougj: "xp_startmail: won't run as non sa user"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
