You can create a dbo-owned proc in an sa-owned user database that
encapsulates your sp_OA* or xp_sendmail calls. If you've enabled
cross-database chaining (introduced in SQL 2000 SP3) in your user
database, users only need execute permissions on your user proc.
Note that cross-database chaining should be enabled only if you fully
trust members of the db_owner and ddl_admin database roles.
Hope this helps.
SQL Server MVP
SQL FAQ links (courtesy Neil Pike):
"Mat" <mat.hornntlworld.com> wrote in message
news:eK2SbUMRDHA.2144TK2MSFTNGP11.phx.gbl...written to> Hi,
> I want to add simple smtp email messages to my database application.
> Basically I have a trigger on a table that when a new record isotherwise I> it an email notification is sent out.
> I'm using the AspMail component and using the sp_OACreate sproc.
> It works fine if the user posting to the table has admin rights,sp_OACreate.> get an error.
> B/O says:
> Only members of the sysadmin fixed server role can execute>
> Is there way round this limitation?
> Any help would be much appreciated.