66af6a00   
   XPost: microsoft.public.sqlserver.server, comp.databases.ms-access,   
   microsoft.public.access   
   From: russellfields@nomail.com   
      
   Bill,   
      
   I believe that they need the view definition right.  If you are happy with   
   view definition being public, then:   
      
   grant view definition to public -- or whoever needs the right   
      
   RLF   
      
   "Bill"  wrote in message   
   news:7fedfd28-c2ca-480f-b797-2121c3bf286f@h2g2000vbd.googlegroups.com...   
   >I manage a SQL 2005 database that has different groups of users using   
   > Access to maintain their data.  Each of these groups of people have   
   > access to a different collection of tables which I implemented using   
   > database roles (ex:  Group A has Role A which gives access to tables   
   > X, Y and Z).  The problem arises when a person attempts to link to the   
   > tables in the sql database for the first time.  The link table process   
   > via ODBC does not show any tables.  The workaround I have is to   
   > elevate their database permissions to db_datareader which lets them   
   > link to the tables.   
   >   
   > What I am trying to figure out is what objects, besides the tables in   
   > their respective role, do these folk need access to to be able to see   
   > the sql server tables?   
   >   
   > Bill   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)