Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Can you explain the keywords in Section Access?

Hi Friends,

I got interview point of question, can you please explain that one.

Thanks&Regards

Ramesh

7 Replies
Not applicable

Re: Can you explain the keywords in Section Access?

Hi,

We can use [section access] & [section Application] keywords we can use to build section access

Not applicable

Re: Can you explain the keywords in Section Access?

section access levels are assigned to users in one or several tables loaded within the section access. These tables

can contain several different user-specific system fields, typically USERID and PASSWORD, and the field

defining the access level, ACCESS. All Section Access system fields will be used for authentication or

authorization. The full set of section access system fields are described below.

None, all, or any combination of the security fields may be loaded in the access section. It is thus not necessary

to use USERID – an authorization can be made using other fields, e.g. serial number only.

ACCESS A field that defines what access the corresponding user should have.

USERID A field that should contain an accepted user ID. QlikView will prompt for a User ID and

compare it to the value in this field. This user ID is not the same as the Windows user

ID.

PASSWORD A field that should contain an accepted password. QlikView will prompt for a Password

and compare it to the value in this field. This password is not the same as the Windows

password.

SERIAL A field that should contain a number corresponding to the QlikView serial number.

Example: 4900 2394 7113 7304

QlikView will check the serial number of the user and compare it to the value in this

field.

NTNAME A field that should contain a string corresponding to a Windows NT Domain user name

or group name.

QlikView will fetch the logon information from the OS and compare it to the value in

this field.

NTDOMAINSID A field that should contain a string corresponding to a Windows NT Domain SID.

Example: S-1-5-21-125976590-4672381061092489882

QlikView will fetch the logon information from the OS and compare it to the value in

this field.

NTSID A field that should contain a Windows NT SID.

Example: S-15-21-125976590-467238106-1092489882-1378

QlikView will fetch the logon information from the OS and compare it to the value in

this field.

OMIT A field that should contain the field that should be omitted for this specific user. Wildcards

may be used and the field may be empty. A facile way of doing this is to use a

arulsettu
Honored Contributor III

Re: Can you explain the keywords in Section Access?

Not applicable

Re: Can you explain the keywords in Section Access?

syntax:

section access:

load * inline

[

]

section application;

load * inline [

]

Here section access is for building the security.

section application is for  allowing the user to what to see or what  not to see

Not applicable

Re: Can you explain the keywords in Section Access?

Hi Ramesh,

take a look at this

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

Joe

Not applicable

Re: Can you explain the keywords in Section Access?

Hi,

Here we have [ Section Access] , [Section Application] Keywords we can use to develop security.

In that we have ADMIN, USER,PASSWORD,NTNAME,NTDOMAINID. ETC.. like this we have Fields

we can build the security like this

SECTION ACCESS;

load ADMIN,USER,PASSWORD from filename;

SECTION APPLICATION;

Partner
Partner

Re: Can you explain the keywords in Section Access?

Hi

Please go through the following document, I'm sure it'll help

Section Access in Qlik Sense.

All the Best.

Regrads,

Pahlad.