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.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Adding Members To DatabaseMailUserRole

Author  Topic 

Tyecom
Starting Member

12 Posts

Posted - 2007-11-15 : 12:13:18
I'm new at SQL. But I am trying to add a user to DatabaseMailUserRole. I found a sample script, but don't know how to edit it:

sp_addrolemember @rolename = 'DatabaseMailUserRole',
@membername = '<database user>'

I'm trying to add "Student" to the DatabaseMailUserRole. Please show me the SQL statement to do this. Thanks in advance.

igorblackbelt
Constraint Violating Yak Guru

407 Posts

Posted - 2007-11-15 : 14:20:59
This link might help you, for future reference, you might want to post these type of questions at the DBA forum (http://www.sqlteam.com/forums/forum.asp?FORUM_ID=36).

http://msdn2.microsoft.com/en-us/library/ms187540.aspx
Go to Top of Page
   

- Advertisement -