do not show data on open (security question)

Anonymous — Fri, 02 Feb 2018 12:20:57 GMT

Lets say I have a table:

LOAD * INLINE [

Name, Score

mark, 1

John, 2

Pam, 3

Dan, 4

];

and I have a straight table showing the data

now I decide to remove data about John and Pam because they are confidential

so I change my table to

LOAD * INLINE [

Name, Score

mark, 1

Dan, 4

];

but I do not reload the data, then I save and share the qvw.

then when one open the qvw they will still see John and Pam until they reload the data.

I thought maybe to add an macro and trigger it on open (as per Auto reload on open

Sub ReloadOnOpen

ActiveDocument.Reload

End Sub

...But for half a second until the reload is launch one can still see John and Pam.

Thoughts?

Many thanks

Raphael

Re: do not show data on open (security question)

petter — Fri, 02 Feb 2018 12:38:24 GMT

You should implement "Section Access". What you do is not any proper security.

Have a look here: