topic Re: What is meant by Basic NT security ?? in QlikView

What is meant by Basic NT security ??

nikhilgarg — Wed, 05 Nov 2014 06:09:14 GMT

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

Re: What is meant by Basic NT security ??

djsampat — Wed, 05 Nov 2014 06:10:02 GMT

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

Re: What is meant by Basic NT security ??

SunilChauhan — Wed, 05 Nov 2014 06:13:26 GMT

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

Re: What is meant by Basic NT security ??

ashfaq_haseeb — Wed, 05 Nov 2014 06:16:10 GMT

Hi,

Check this

Regards

ASHFAQ

Re: What is meant by Basic NT security ??

ashwanin — Wed, 05 Nov 2014 06:19:51 GMT

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.

Re: What is meant by Basic NT security ??

nikhilgarg — Wed, 05 Nov 2014 06:27:12 GMT

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

Re: What is meant by Basic NT security ??

SunilChauhan — Wed, 05 Nov 2014 06:32:04 GMT

subfield(OSuser(),' ',2)

Re: What is meant by Basic NT security ??

its_anandrjs — Wed, 05 Nov 2014 06:37:26 GMT

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

Re: What is meant by Basic NT security ??

SunilChauhan — Wed, 05 Nov 2014 06:40:17 GMT

=upper( Mid(OSUser(), Index(OSUser(),' ')+1,len(OSUser())))

Re: What is meant by Basic NT security ??

djsampat — Wed, 05 Nov 2014 06:56:24 GMT

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