|
|
Posted by Dan Guzman on 10/01/43 11:32
Does the user have permissions on the table? In that case, the table will
be visible in the list.
--
Hope this helps.
Dan Guzman
SQL Server MVP
"Morten Mikkelsen" <mbmnewsreader_@_mikkelsens.net> wrote in message
news:437fa8ec$0$47014$edfadb0f@dread15.news.tele.dk...
> Dan Guzman wrote:
>
>> You can specify WITH VIEW_METADATA so that only meta-data exposed by the
>> view is visible:
> >
>> CREATE VIEW MyView
>> WITH VIEW_METADATA AS
>> SELECT MyPublicData FROM MyTable
>
>
> This is a bit better.
> However, now, when using excel to extract the data, the query designer
> shows both MyView and MyTable in the dropdown for selecting the source.
> If I select the table as source, the secret columns still show up.
> How do I remove the table from the list of selectable choices while still
> allowing them to select the data from it through the view?
>
> TIA,
> /M
>
Navigation:
[Reply to this message]
|