Qlik Community

QlikView Security & Governance

Discussion Board for collaboration on QlikView Security and Governance.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kjmahesh
Contributor

sheet Level access

Hi All,

i have qvw in these iam having sheet1 and sheet2  , and i want to provide these sheet2 access to particular users .

user details :

uday.kumar@outlook.com

when user uses these userdetails to login then only sheet2 should be visible others should see all the  sheet1 .

can any one help me on these .

Thanks In advance !

Tags (1)
7 Replies
vardhancse
Valued Contributor II

Re: sheet Level access

Section Access;

LOAD ACCESS,

     NTNAME,

     SAREP,

     NM

FROM

'..\..\..\Dashboard\SectionAccess.xlsx'

(ooxml, embedded labels, table is SA);

Then you add the sheet access coding directly underneath

Section Application;

Sheet_Security:

LOAD USERS as NM,

     SH01,

     SH02,

     SH03,

     SH04,

     SH05,

     SH06,

     SH07,

     SH08

FROM

'..\..\..\Dashboard\SectionAccess.xlsx'

(ooxml, embedded labels, table is SHEETS);

My Section Access table looks like you would expect and the NM column is to specify their role, MGR or NON for different sheet access, i.e.

NTNAME   SAREP   NM

him            Richard   NON

her             Mike       NON

mgr1           *            MGR

mgr2           *            MGR

and the Sheets Table looked like so:

USERS  SH01  SH02  SH03.... SH07 SH08

NON         1         1         1           0        0

MGR         1         1         1           1        1

Then set the condition property for each respective sheet to show if the flag for that sheet is 1, i.e.:

SH08=1

Then reload!

hemanthaanichet
Contributor III

Re: sheet Level access

Hi Mahesh,

Refer the below link:

QlikView Section Access Examples

it might be very helpful

Regards

Hemanth

kalyanivintha1
Contributor II

Re: sheet Level access

Hi,

suppose if you have sheet1 and sheet2 in your application.

you can apply section access like this...as fallows

In section access we must have to give some basic credentials these are

ACCESS-access type ntg but this user is admin or user

USER ID-user id is credential to user ntg but username

PASSWORD-we have to give the passwords for every users.

and

if you want to apply at sheet level..you have to add additional credentials like sheet names you have to add in

section access.

at sheet level credential you want to display that sheet to particular user you have to add 1 in that user.

you don't want to display that sheet to particular user you have to add 0.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, SHEET1, SHEET2

    ADMIN, ADMIN, 123, 1, 1

    USER, USER1, 1234, 1, 0

    USER, USER2, 1235, 0, 1

];

Section Application;

from this..admin will see the both the sheets

user1 will see the sheet1 only

and

user2 will see the only sheet2.

Thanq.

satheshreddy
Contributor III

Re: sheet Level access

Hi Mahesh,

we have to create section access for this like below.

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD

    ADMIN, ADMIN, ADMIN

    USER, SA, SA

    USER, TA, TA

];

Reload the QVW File and go to sheet Properties..

Genaral Tab:

Show Sheet :

Conditional: here we have write like below.

=QVUSER()='SA'

PRESS OK.

CLOSE THE QVW File And login with TA. TA user Don't Have Access sheet 1 so its not visible.

Regards

Sathish.

kjmahesh
Contributor

Re: sheet Level access

Hi Kalayani.

Thanks for providing the detail information for the sheet level access  very easy to understand .

but i have question here

I  cant the information  of the password from the user .

my changeling  is when ever  user use his Credentials  as  username based on that sheet should be visible .

for Eg: if user is logged with mahesh@polash.com  then user should be able  to his sheets .

Sry if my question not clear.

can you help me to solve this issue.

Thanks in advance !

Regards

Mahesh.

kalyanivintha1
Contributor II

Re: sheet Level access

Hi Mahesh,

you have to set the passwords as of you and your client understanding.

and

Your Requirement is ..

you have to show  sheet2 information  to only one particular user and remaining for all the users you don't want to show the sheet2 information right.

suppose if you want display sheet2 information to only user3 and remaining all the users can't see the sheet2 information,

and admin also can't see the sheet2 information when you are going to log in with admin credentials initially.

but after reloading the application in admin level .admin can access all the sheets information along with sheet2.

and normal users at any cost they didn't see the sheet2 information.

and user3 can only access the sheet2 information at any cost.


you can do like this:

Section Access;

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, SHEET1, SHEET2

    ADMIN, ADMIN, 123, 1, 0

    USER, USER1, 1234, 1, 0

    USER, USER2, 1235, 1, 0

     USER,USER3,1236,0,1

];

Section Application;

and

I given the reply as of i understand your requirement,

this is not your final requirement,

share the what is your exact requirement,

Thanq.

satheshreddy
Contributor III

Re: sheet Level access

hi Mahesh,

have checked my post...

Regards

Sathish

Community Browser