Results 1 to 3 of 3
  1. #1
    RayMilhon is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,066

    SQL Server Permissions


    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.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    I've never used them, but a quick search reveals you can:

    https://technet.microsoft.com/en-us/...=sql.105).aspx
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    NoellaG's Avatar
    NoellaG is offline VIP
    Windows 7 Access 2010 (version 14.0)
    Join Date
    Jun 2010
    Location
    Belgium
    Posts
    1,035
    You can set the permissions by column, you can check this by checking the permissions of the group you belong to or your individual user permissions (show user properties -> tab securables -> select or add table -> click select -> click column permissions). Check also the format of the missing columns, they might not be compatible with access (example: bigint or varchar(max) can give problems)

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Upgrade from SQL Server 2008 to SQL Server 2014
    By RayMilhon in forum SQL Server
    Replies: 4
    Last Post: 07-12-2017, 04:54 PM
  2. SQL Server function needs permissions
    By EuniceH in forum SQL Server
    Replies: 2
    Last Post: 07-03-2014, 10:43 AM
  3. Replies: 1
    Last Post: 05-17-2012, 05:51 PM
  4. MDB Permissions
    By esbrega in forum Security
    Replies: 0
    Last Post: 03-08-2012, 03:46 PM
  5. You don't have the necessary permissions
    By registan in forum Access
    Replies: 11
    Last Post: 02-19-2012, 12:53 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums