|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Monday, April 16, 2012 2:58 AM
Points: 1,
Visits: 6
|
|
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
|
|
|
|