Discussion Board for collaboration on QlikView Security and Governance.
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)
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
(biff, embedded labels, table is [Sheet1$])
Upper(SECURITYLINK_TERRITORY) as SECURITYLINK_TERRITORY,
(TerritoryCode) As [Territory Code]
(biff, embedded labels, table is [Sheet2$])
Upper('ALL') as SECURITYLINK_TERRITORY,
[Territory Code] As [Territory Code]
Spreadsheet contents (Sheet1):
ACCESS USERID NTNAME SECURITYLINK_TERRITORY
USER PDBDeveloper CUSTOM\PDBDeveloper REGION_4
I recently had a similar issues, with QV 11.2 SR5, that I could not get both USERID & NTNAME Section access working. To get it working I eliminated all the USERID elements as time was pressing.
This certainly is not a solution, but I will follow this thread with interest.
Best Regards, Bill
It's not even both, I'm just trying to switch, but seem to be hitting something
Tried a bunch of things on my own, but figure it's best to ask before continuing to blow too much time on it.