topic Re: Doubt In Section Access in QlikView

Doubt In Section Access

NavinReddy — Fri, 17 Oct 2014 14:25:40 GMT

Dear Experts,

I Developed one Qlikview Application Now i want to share this to some users,

Here im getting confused here where i am suppose to develop section access,

In Qlikview Application OR while sharing to the users in QVMC there should i develop the section access

I want to develop section access using NTNAME, This is first time im trying please help me

If i am thinking wrong please correct me ,i am little bit confused

And if any Sample Section Access App developed by using NTNAME please share to me it would be great help

Thanks In Advance

Niranjan

Re: Doubt In Section Access

JonnyPoole — Fri, 17 Oct 2014 15:23:12 GMT

To employ section access you need to add the section access script into a QVW. There is a SA table in the script plus a script command to employ it.

The actual script (usually the table) can be stored external to the QVW in a database and queried like any table. Or it can be referenced from an external file via an INCLUDE statement , OR called from a centralized section access table that you defined in the QMC. The last is relatively new: but the SA table in the QMC is just a repository that QVWs can dynamically pull from when they are refreshed.

Re: Doubt In Section Access

NavinReddy — Fri, 17 Oct 2014 15:53:38 GMT

Hi Jon,

Thanks For your detailed explanation,

You mean to say SA should be developed in QVW only ,What we will do with QMC

Then QMC when i deploy the QVW he can able to access the QVW in Access point with the NTNAME

if you have sample script or sample QVW it would be great help to me

Thank you so much again

Best Regards,

Niranjan

Re: Re: Doubt In Section Access

ashfaq_haseeb — Sun, 19 Oct 2014 06:56:19 GMT

Hi,

have a look at attached file

Regards

ASHFAQ

Re: Doubt In Section Access

NavinReddy — Mon, 20 Oct 2014 13:34:57 GMT

Hi Mohammed,

I tried but im getting confused in script side how to use NTName ,is it required password

Then with out password how he will access QVW in Access point,

I have Completed QVW now based using NTName i want to develop Security where can i develop security,

In QVW Application or QMC

Please im totally confused ,guide me this is first time im developing Security

If you have Sample Security file developed by using NTNanme

Best Regards,

Niranjan

Re: Doubt In Section Access

Anonymous — Mon, 20 Oct 2014 14:02:30 GMT

Hi,

The script should for section access should be something like this:

SECTION ACCESS;

AccessTable:

LOAD * INLINE [

ACCESS,NTNAME

ADMIN,Domainname\ABC

ADMIN,Domainname\DEF

User,Domainname\XYZ

];

SECTION APPLICATION;

\\Follows the Data model Scripts

Re: Doubt In Section Access

Mon, 20 Oct 2014 14:21:27 GMT

Hi niru,

How r u man...this is sra1

SECTION ACCESS;

AccessTable:

LOAD * INLINE [

ACCESS,NTNAME

ADMIN,Domainname\ABC

ADMIN,Domainname\DEF

User,Domainname\XYZ

];

SECTION APPLICATION;

NTNAME is the OSUSER() in Qlikview.

you need to give your all users NTNAME in the script.when they are openings the application it will check whether the systems NTNAME is that list or not.then once the NTNAME finds the application will open to the end user.

Re: Doubt In Section Access

NavinReddy — Mon, 20 Oct 2014 17:11:50 GMT

Hi,

Thanks to All for your valuable suggestions

Best Regards,

Niranjan

Re: Doubt In Section Access

ashfaq_haseeb — Mon, 20 Oct 2014 18:59:08 GMT

Hi,

Have a look at below videos

QlikView Security Video Series | Qlik

If it answered, then close this thread by selecting appropriate answers.

Regards

ASHFAQ