In SQL Server 2012 is it possible to give permissions by column? I have a database in SQL Server 2012 Standard that is maintained at our corporate office. My login has public access. I use MS Access 2010 connecting through ODBC to run my reports. What I've noticed is that when connecting through ODBC several of the columns I use the most are missing. If I look at the table through SQL Server Manager they are there it's only when linking through ODBC do they vanish. I need to figure out what the issue is so it can be corrected and I can run my reports. One of the required fields is the Primary Key in my linked table and it's not there when I link to sql server.