CODEWITHSUNDEEP
sql-serversql-server-2005permissionssql-server-2008-r2dbmail
Will Kyle
Will Kyle

Reputation: 1

SQL database Mail Password change permissions

SQL Server 2005 / SQL Server 2008 R2

I have to make use of email accounts with Database Mail whose passwords have a life of 90 days so therefore have to ensure that smtp Authentication passwords are updated in a timely fashion.

I currently have a new member of staff for whom I do not wish to grant System Admin (SA) privileges to. However I would like them to be able to update DB Mail passwords in my absence which I understand do require SQL SA rights.

Does anyone know anyway around this and how I can grant/configure this specific privilege?

Upvotes: 0

Views: 1458

Answers (0)

Related Questions