|
|
Posted by Morten Mikkelsen on 10/01/87 11:32
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]
|