What is meant by Basic NT security ??

[nikhilgarg]

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

[djsampat]

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

[SunilChauhan]

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

[ashfaq_haseeb]

Hi,

Check this

Regards

ASHFAQ

[ashwanin · Accepted solution]

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.

[nikhilgarg]

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

[SunilChauhan]

subfield(OSuser(),' ',2)

[its_anandrjs]

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

[SunilChauhan]

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

[djsampat]

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