Sample Header Ad - 728x90

Prevent users from sending an email attachment in sql server

1 vote
2 answers
141 views
In SQL Server, I want to restrict all users (except a few specific users) to send an email with attachment. For example, someone import data into excel file and send it via mail using the sp_send_dbmail procedure. Can we restrict use of this procedure? Or is there any other way to do it? There are some users that have sysadmin permission, I want to restrict them too. If it is not possible, at least I want to get notification when someone sends an email with attachment. Trigger or procedure might work, but I could not get any result.
Asked by Farid Zahidov (41 rep)
Feb 20, 2024, 06:58 AM
Last activity: Feb 22, 2024, 12:33 PM