Observed behavior:
If I use USERID, works as expected
If I use NTName, does NOT work as expected
* Only change is commenting out the UserID line and uncommenting the NTName line*
Note that both userid and NTName are on the same line, and no other document settings were changed
On opening, see the OSName() shown as 'CUSTOM\pdbdeveloper', and the QVUser() = filled in (for USERID, shows entry, for NTNAME, shows nothing, but seems to verify that I'm using the 'Correct' NTName)
Key areas:
Directory;
Section Access;
NoConcatenate
Access:
Load
Upper(ACCESS) as ACCESS,
Upper(USERID) As USERID, // Works, but asks for double login
// UPPER(NTNAME) As NTNAME, // Gets login working, shows as NTName, but fails to do restriction
Upper(SECURITYLINK_TERRITORY) as SECURITYLINK_TERRITORY
FROM
[.\Excel Helpers\QuoteAccess.xls]
(biff, embedded labels, table is [Sheet1$])
;
Section Application;
Later on:
NoConcatenate
SecurityLinkTbl_Territory:
Load
Upper(SECURITYLINK_TERRITORY) as SECURITYLINK_TERRITORY,
(TerritoryCode) As [Territory Code]
FROM
[.\Excel Helpers\QuoteAccess.xls]
(biff, embedded labels, table is [Sheet2$])
;
Concatenate
SecurityLinkTbl_Territory:
Load Distinct
Upper('ALL') as SECURITYLINK_TERRITORY,
[Territory Code] As [Territory Code]
Resident Territory;
Spreadsheet contents (Sheet1):
ACCESS USERID NTNAME SECURITYLINK_TERRITORY
ADMIN ADMIN
USER PDBDeveloper CUSTOM\PDBDeveloper REGION_4
Sheet2:
SECURITYLINK_TERRITORY TerritoryCode
REGION_4 A37
REGION_4 A38
REGION_4 A39
