I am trying to create a minimum privilege (read only) role which can select from a few tables, through ODBC for an application. When I do this though and test the ODBC using EXCEL, I can see several sys views and also dm views and master db objects.
How can I tie all of these down without individually 'revoking' the select access to these on the role?
Can I create a role which by default will do this? See only those tables that I allow it to, and NOTHING else.
Thanks in advance.
sk