January 24, 2014 at 5:36 pm
Hi all,
I have a sever with 12 databases on it. Application user app_user needs access to run 3 stored procs in 3 different user databases.
One of the procs is an error logging procedure is calling sp_send_dbmail.
Here is what I've done:
- created login with server role: public and mapped this login to 3 user databases and msdb (for sp_send_dbmail)
- went to each database/securables and granted execute on procedure it needs
When app_user connected and tried to run one of the procs, the call to sp_send_dbmail failed with "invalid profile" message
How do I go about granting the right privs to that user.
January 24, 2014 at 5:40 pm
"invalid profile" is not an exact error. Can you cut and paste the full error message here?
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
January 24, 2014 at 5:43 pm
Msg 14607, Level 16, State 1, Procedure sp_send_dbmail, Line 141
profile name is not valid
January 25, 2014 at 6:35 pm
You need to add a profile to the dbmail. It's not security for the login, it's setup for the sysmail profile for the login
Check out msdb.dbo.sysmail_add_principalprofile_sp.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply