Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Does admin(user) rights is required in document with section access

Hi All,

I don't have the admin user in my section access part. As per the document it says that admin user have the authority to restrict edit script,reload,save,etc options for the non admin user. But i admin user is not there in my document. Is there is any way to reduce restrict the user from accessing edit script,reload,save,etc options. Is it must that all the document with section access must have the admin user to restrict the non admin user? As currently we don't want the admin rights in our document.

Also let me know is it necessary that user name should only be 'admin' for the admin user. Can't it be with different name. Something like vadmin or administrator???

Hope some one will let me know the best possible way.

116 Replies
Not applicable
Author

Hello Sajeevan!

The solution provided my Mr. Rakesh seems to be work in the below post of mine. Please kindly look into it and let me know if you have any solution for the problem which is there in the last post(How to restrict sheet wise access after this).

http://community.qlik.com/forums/t/25669.aspx

Waiting for your reply!

Not applicable
Author

Hi Rikab,

Click the sheet where you want to restrict access, right click and select sheet properties, select the general tab, select conditional in show sheet panel then write the condition for displaying that page.

Thanks,

Sajeevan

Not applicable
Author

I did there only once I wrote the condition and click on apply the sheet got disappeared though I was in admin login. Let me know why it is happening like that.

Not applicable
Author

Hi Rikab,

It will be disappeared if the condition do not satisfy for you even if you are an admin user. What was the condition written?

Thanks,

Sajeevan

Not applicable
Author

condition = Sum(SH01)>=1

<pre>Sheet_Mapping:
LOAD * INLINE
[
ACCESS, SH01, SH02
USER, 1, 0
ADMIN, 1, 1
];

Not applicable
Author

Hi Rikab,

I think using ACCESS again can be an issue. Can you send me the Section Access script as well.

Thanks,

Sajeevan

Not applicable
Author

Have attached the same!

Not applicable
Author

Hi Rikab,

Thanks, I was about to leave office.

Please find attached the modified script. I am not sure whether you can use variables like SH01, SH02 because it is the sheet object id.

I have added a variable called "SecurityPage" in SecurityTable and loading "Some" for USER access and "ALL" for admin access.

Then the SecurityPage variable is linking with "SH_01", "SH_02" in another inline load after section Application.

You need to change the condition variable as SH_01, SH_02 etc rather using the sheet id.

Hope this will solve the page access issue.

Thanks,

Sajeevan

Not applicable
Author

Hi Sanjeevan!

Thanks it works! Previously in I was using this variable(SH01) in one of my document and it worked don't know why the same thing is not working in current document. We need to find out the reason for that.

Thanks and Regards,

Rikab

Not applicable
Author

Hi

Please check my last post of mine in this thread. I am facing serious problem. Please try to check and help me out.

http://community.qlik.com/forums/t/25669.aspx

Thanks and Regards,

Rikab