Document with Section Access opens with no authentification

[Anonymous]

I have evoked Section Access into my QV document as follows:

Section Access;
Directory;
LOAD ACCESS,
USERID,
PASSWORD,
RETAILPHARMACY,
OMIT,
PATENTS,
FDA,
GENERICS,
SHOPPING,
PLAZA_ANALYTICS,
_VIEWGROUP
FROM
[..\Data Files\SectionAccess.xlsx]
(ooxml, embedded labels, table is SectionAccess);

To my surprise, the document is opening without entering any USERID and PASSWORD credentials,  What could be the cause for this?

Regards.

[tresesco]

Did you try:

Remove '*' from USERID column and reload the app.

I suggested above?

[Anonymous]

MANY thanks Tresesco, that works.  Removing '*' fro USERID column is the solution.  Can you explain the reason behind this.

Regards

[tresesco]

I would interpret this like:

When '*' is used in any system field, it is interpreted as ALL (not even the values listed). From help:

A wildcard, i. e. *, is interpreted as all (listed) values of this field, i.e. a value listed elsewhere in this table. If used in one of the system fields (USERID, PASSWORD, NTNAME or SERIAL) in a table loaded in the access section of the script, it is interpreted as all (also not listed) possible values of this field.

Now perhaps, for USERID and PASSWORD fields null() is a possible value. So the qv gets authenticated with nothing, i.e.- 'with no authentication'.  Hope this makes sense.

Update: I did one more round of testing and it looks like - it's rather because of PASSWORD and USERID field '*' . The '*' explanation still stands good.

[sasikanth]

hi,

but i have loaded the Excel file in a separate application and it is working fine

PFA,

[Anonymous]

Thanks

[Anonymous]

Thanks Sunny, did you do any changes to the file?

[sasikanth]

NO, i didnt do any chanhes , just loaded the file between Section access and Section application