» Transact SQL
» SQL Server security (RSS)
Sorry, but there are no more tags available to filter with.
Suppose that Bob can retrieve all messages, as follows, and we are not happy with it:
Suppose that we don't want him to read anything related to messages, so our knee-jerk reaction is this:
REVOKE EXECUTE ON Exchange.ShowAllMessages FROM Bob ;
This does not work - Bob still can execute ...