Good day everyone,
Iam trying to limit the access for SQL 2005; I created a role designed to select tables and views only; i added table and view securables, and chose it one by one; what do i need to choose under the list of explicit permissions. I tried using just the select and still not working; they still dont have access on the specific table; need your help. what other permissions do i need to grant?
thanks in advance,