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

[#1]

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.

[#2]

Thanks but did u made any modification in that? Even mine was working? Was there was anything wrong in that.

Also you did not attach any files...

[#3]

Hi Rikab,

I did some changes and attached the file. Please check

Thanks,

Sajeevan

[#4]

Hello Sanjeevan,

I commented my understanding about the script that you have used. Let me know whether I am right or wrong.

Section Access;

//Gives access to the admin of the document who can access everything in the document

LOAD * INLINE [
ACCESS, USERID, PASSWORD, SECURITYMFA, SECURITYPAGE
ADMIN, ADMIN, ADMIN, ALL, ALL
];

LOAD DISTINCT
 'USER' as [ACCESS] // User as access
 ,upper([userid]) as [USERID] // userid
 ,upper([password]) as [PASSWORD] //password
 ,if(userid='001001admin' or userid='001001vadmin','ALL',upper(mfaccode)) as SECURITYMFA // if the userid is '001001admin' or '001001vadmin' it will send 'ALL' as securitymfa else mfaccode as securitymfa
 ,if(userid='001001admin' or userid='001001vadmin','ALL','Some') as SECURITYPAGE // if the userid is '001001admin' or '001001vadmin' it will send 'ALL' as securitypage else mfaccode as securitypage
resident items;

section Application;
star is *;

//Allows admin to see all the mfac data

load * INLINE [
SECURITYMFA, mfaccode
ALL,*
];

//Gives page wise access for admin and user

load * inline [
SECURITYPAGE, SH_01,SH_02
ALL, 1, 1
Some, 1, 0
];

// I know what the below code does but sure why and where it is used

load distinct
 if(userid='001001admin' or userid='001001vadmin','ALL',upper(mfaccode)) as SECURITYMFA, //if the userid is '001001admin' or '001001vadmin' it will send 'ALL' as securitymfa else mfaccode as securitymfa
 if(userid='001001admin' or userid='001001vadmin','*',upper(mfaccode)) as mfaccode //if the userid is '001001admin' or '001001vadmin' it will send '*' as securitymfa else mfaccode as mfacode
resident items;

Thanks and Regards,

Rikab

[#5]

Hi Rikab,

This is exactly what I have commented in the QVW file I uploaded. I don't understand your confusion!

Thanks,

Sajeevan

[#6]

Sajeevan wrote:
This is exactly what I have commented in the QVW file I uploaded. I don't understand your confusion!<div></div>

Its been very long since I am working on this. So there has been lots of changes in the script though it is very simple. That's where the confusion is!

Really sorry for all those trouble that I had given all these days.

Many thanks to you!

Regards,

Rikab

[#7]

Hi Sajeevan,

There is one more doubt for me.

load * INLINE [
SECURITYMFA, mfaccode
ALL,*
];

When we are using the below script which does the same purpose like the above one. May I know why it is required. Is it required to define the column name (SECURITYMFA,mfaccode) ????

load distinct
 if(userid='001001admin' or userid='001001vadmin','ALL',upper(mfaccode)) as SECURITYMFA,
 if(userid='001001admin' or userid='001001vadmin','*',upper(mfaccode)) as mfaccode
resident items;
<pre>
Do clarify me
Thanks and Regards,
Rikab</body>

[#8]

Hi Rikab,

The inline load will just add one line of data. The subsequent load will load "ALL" and "*" for admin again - not an issue. It will load the mfaccode for other users in SECURITYMFA variable and mfaccode variable - This is required to reduce the data when the user logs in.

Thanks,

Sajeevan