topic Re: Username Security - Help in QlikView

Username Security - Help

Mon, 17 Sep 2012 10:24:03 GMT

I am currently trying to add better security into my applications by using the username of the user with: -

OSuser()

I have created a very simple inline load with username and access which is then mapped on to the main table against OSuser(). I then use a 'Where' statement based on the access to either keep or drop the data.

ACCESS:

LOAD * INLINE

[

User, Access

USER\joe.bloggs, 1

];

accessmap:

MAPPING LOAD

User,

Access

RESIDENT ACCESS;

DROP TABLE ACCESS;

MAIN:

OSUSER() as User

MAIN2:

a as a1,

User

RESIDENT MIAN

WHERE applymap('accessmap', User) = 1;

DROP TABLE MAIN;

The only problem with this is that the application needs to reload automatically each time it is opened......is this possible? and if so how can you do it?

Failing that is there a better way to add security based upon OSuser()??

Re: Username Security - Help

Miguel_Angel_Baeyens — Mon, 17 Sep 2012 10:28:20 GMT

Hi,

If you are using OSUser() you must use the NTNAME instead. Besides, you will need to add the ACCESS field, with values of ADMIN or USER depending on the account. Check this thread among others on how to build a section access using NTNAME.

Hope that helps.

Miguel

Re: Username Security - Help

kaushiknsolanki — Mon, 17 Sep 2012 10:29:48 GMT

Hi,

Have a look at the below link to learn about implementing security in QlikView.

http://community.qlik.com/docs/DOC-1853

Regards,

Kaushik Solanki

Re: Username Security - Help

Mon, 17 Sep 2012 10:35:32 GMT

Thanks to you both for the swift reply.