Preventing Bob from sales from selecting other people's messages

re: Preventing Bob from sales from selecting other people's messages

Alexander Kuznetsov — Fri, 19 Aug 2011 14:30:28 GMT

GrumpyOldDba,

When I deleted a spam comment above yours, your comment was gone as well. I asked Adam to restore it.

Alexander Kuznetsov — Fri, 19 Aug 2011 14:35:08 GMT

GrumpyOldDba,

It seems unlikely that your comment will be restored. Can you please repost it?

Uri Dimant — Wed, 24 Aug 2011 07:42:12 GMT

Sasha, I think the below should be working (sorry untested)

ALTERPROCEDURE Sales.ShowMySalesWithBackDoor

WITH EXECUTE AS 'dbo'

BEGIN ;

-- do something here

IF SUSER_NAME() = 'Bob'

BEGIN ;

EXEC Exchange.ShowAllMessages ;

END ;