Home Forums SQL Server 2005 SQL Server 2005 Security Having trouble granting user login select permission on msdb.sysmail_allitems RE: Having trouble granting user login select permission on msdb.sysmail_allitems

  • Agreed. I had a sproc that referenced the view msdb.dbo.sysmail_allitems and no matter how I changed the permissions I could not get it to return records. When I changed that sproc to reference the table msdb.dbo.sysmail_mailitems I had access to essentially the same data.