[dba-SQLServer] Field missing in Linked SQL Table/View

[Stuart McLachlan]

Yes.

https://technet.microsoft.com/en-us/library/ms180341%28v=sql.105%29.aspx

and more detail:

https://www.mssqltips.com/sqlservertip/2124/filtering-sql-server-columns-using-column-level-
permissions/



On 14 Jan 2016 at 9:02, David Emerson wrote:

> Hi Paul,
> 
> Can permissions be set on a field?  I have no problem linking to the
> table.
> 
> Regards
> 
> David
> 
> -----Original Message-----
> From: dba-SQLServer
> [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of Paul
> Hartland Sent: Thursday, 14 January 2016 8:32 a.m. To: Discussion
> concerning MS SQL Server Subject: Re: [dba-SQLServer] Field missing in
> Linked SQL Table/View
> 
> Just off hand it sounds like a permissions thing, do you use the same
> logon to run the view in SQL server as you are using for the linked
> tables to Access ?
> 
> On 13 January 2016 at 18:40, David Emerson <newsgrps at dalyn.co.nz>
> wrote:
> 
> > Hi Listers,
> >
> > I have an SQL 2012 database that belongs to another application
> > which I have little control over.  I am allowed to create views of
> > the tables.  I have created a view of a particular table which just
> > selects a few of the fields from the table.  I have then linked the
> > view to my Access 2010 database.
> >
> > The unusual thing is that one of the fields does not appear in the
> > linked table in Access.  It is definitely in the view and appears
> > when I run the view.
> >
> > I have tried linking directly to the SQL table and this includes all
> > the fields except for the same field missing from the view.
> >
> > I have changed the view and relinked it - all of the changes show in
> > the linked table except the same field doesn't show.
> >
> > There is nothing unusual I can see about the field.  It is a
> > nvarchar(25). The type is a user defined data type but so are a
> > number of other fields that all appear in the linked table.
> >
> > Has anyone come across this before?
> >
> > Regards
> >
> > David Emerson
> > Dalyn Software Ltd
> > Wellington, New Zealand
> 
> _______________________________________________
> dba-SQLServer mailing list
> dba-SQLServer at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
> http://www.databaseadvisors.com
> 
>