Hello,

With SQL Server 2008 (at least) there is a problem

DENY SELECT ON OBJECT::MA_TABLE(DUMMY_COLUMN) TO User1;

work like a charm (return an error) when I try to make a "SELECT *"

but in a stored procedure I can do a "select *"

CREATE PROCEDURE [dbo].[myProc]

AS

BEGIN

SELECT * FROM MA_TABLE;

END

Why ? I need to get an error when I execute a stored procedure which contains a "SELECT *"

Regards