• I created a role and am applying the deny select and deny exec for stored proc to that role, not changing the public access. I am not trying to foobar up the dbase as it is vital right now but need to be able to create a secure connection from ODBC giving users only a select set of objects(mainly tables) to access. I have been searching for sometime now this week and have not found something that would fit yet. Have you tried what I am suggesting or trying to do in a quick dev environment? I am thrown from the fact that others over the years have not solved or work around this yet or that this is resolved or a resolve posted on this for sql server 2008 yet, seems to be a basic thing that many would come up against. Simply trying to set up a role and user id that a ODBC can get too and only see a select set of tables or objects in parent dbase.

    thanks for your time and knowledge,

    Brett