Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends,
I got interview point of question, can you please explain that one.
Thanks&Regards
Ramesh
Hi,
We can use [section access] & [section Application] keywords we can use to build 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
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
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;
Hi
Please go through the following document, I'm sure it'll help
All the Best.
Regrads,
Pahlad.