Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey,
In Access Restriction Table Wizard :
What is meant by Basic NT security ??
Which id and passwords are used ??
And what is Access there??
Thanks
Hi
NT Security : The security which is applied to the restrict with the name of user
When we applied NT Security, QlikView check first that its NTName (osuser) is matching or not.
=osuser() formula provides you Domain and user name (check it in text box)
While formula =upper( Mid(OSUser(), Index(OSUser(),'\')+1,len(OSUser()))) gives you user name.
It is where you can define users to access the Document using a Domain Name\Username format.
it will use your windows password to authenticate.
You can restrict access to sites/regions/parts of the report/sensitive information by having a security access levels set.
LOAD * inline [
ACCESS,NTNAME,USERID,PASSWORD,COMPANY
];
If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer
Regards
Dhruv
NTSecurity is based on NTName
its use your windows oS Credential and provide access
it should be in form of domain\username
your windows ID and passworld could be users
and access is depent upon section access code writen
like below'
Section access ;
Access ,NTNAme,REgion
ADMIN,skl\sunil,*
User,skl\NIKHIL.East
section application;
here Sunil Has admin access and have access to all regions
and nikhil has east region access
hope this helps
Hi,
Check this
Regards
ASHFAQ
Hi
NT Security : The security which is applied to the restrict with the name of user
When we applied NT Security, QlikView check first that its NTName (osuser) is matching or not.
=osuser() formula provides you Domain and user name (check it in text box)
While formula =upper( Mid(OSUser(), Index(OSUser(),'\')+1,len(OSUser()))) gives you user name.
Hey Ashwani,
Thanks. The trick works well .
But i just want to know the working of :
=upper( Mid(OSUser(), Index(OSUser(),'\')+1,len(OSUser())))
Let say my OsUser value is : ABCSoftware nikhil.garg
Then how does above stated formula extract my user name. Please tell.
Thanks
subfield(OSuser(),' ',2)
Hi,
By this expression =upper( Mid(OSUser(), Index(OSUser(),'\')+1,len(OSUser()))) you get
ABCSOFTWARE NIKHIL.GARG
By this Index('ABCSoftware nikhil.garg','\') you get index of \ that is 15
and this len('ABCSoftware nikhil.garg') length 23
And by this expression
=upper( Mid('ABCSoftware nikhil.garg', Index('ABCSoftware nikhil.garg','\')+1,len('ABCSoftware nikhil.garg')))
You get
ABCSOFTWARE NIKHIL.GARG
Regards
Anand
=upper( Mid(OSUser(), Index(OSUser(),' ')+1,len(OSUser())))
Hi Nikhil.
the formula
=upper( Mid(OSUser(), Index(OSUser(),'\')+1,len(OSUser())))
gives you user name by looking in the middle area of the user name and looking for the "\" (backslash) and then adding 1 so that it skips the slash and the remainder is your name that is changed to UPPERCASE.
so if your separator is a blank space, the swap the \ with a space using single quotes ' ' so it will become
=upper( Mid(OSUser(), Index(OSUser(),' ')+1,len(OSUser())))
Just breaking down the above comments, if they weren't clear.
If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer
Regards
Dhruv