none
DB mail account and profile security RRS feed

  • Question

  • Hi,

    i have created a DB mail account and profile to use mail functionality in sql server.

    I wanted to keep if as safe from other users so that no body should be able to modify account and profile settings which i ahve configured.

    kindly suggest how can i achieve this.


    SQL Server DBA

    Tuesday, June 4, 2019 11:55 AM

All replies

  • Only members of the SysAdmin Server role can modify email profile, common users don't have this permission

    Olaf Helper

    [ Blog] [ Xing] [ MVP]

    Tuesday, June 4, 2019 12:10 PM
  • there are many people having sa role in the environment, is there any way to restrict all of them instead me to change that mail profile and account.

    SQL Server DBA

    Tuesday, June 4, 2019 12:37 PM
  • Nope. SysAdmin has the highest privileges in SQL server and it is right to do so. What if you leave the company? 
    Tuesday, June 4, 2019 12:47 PM
  • There is no way to restrict anything a sysadmin user can do.  It is very bad practice to allow many people to have sysadmin rights.

    Tuesday, June 4, 2019 12:55 PM