• when you use deny VIEW DEFINITION the user cannot see the objects but user can still query(select * from table/view) object if they know the name(s). Again I am using a newly created role and user as not to affect other dbases and systems with this. so this did not work

    thanks

    Brett