Set the Execution Context

When you use xp_sendmail to execute a query that has been submitted via an e-mail message, the query with the privileges of a particular Adaptive Server login in a particular database. This login/database combination is the execution context. By default, the login is “sybmail” and the database is master.

You can set the execution context for individual messages by passing different login and database values to xp_sendmail or sp_processmail with these variables:

dbuser – to reset the login name, which must represent a valid Adaptive Server account on the target Adaptive Server.
dbname – to reset the database name.

Name Both the User and the Database
Specify dbuser and dbname to control how Adaptive Server executes a query.
Name the User But Not the Database
Specify only dbuser to execute the command, xp_sendmail, or sp_processmail, in the master database.
Name the Database But Not the User
Specify only dbname to set the default dbuser as “sybmail” to execute any query under the user context of “guest”.
Name Neither the User Nor the Database
Specify neither parameter to retain the default dbuser as “sybmail” and the default database as master. Adaptive Server executes the e-mail query as “guest” in the master database.

Parent topic: Sybmail Security