Section Access

[priyarane]

Hi Experts,

How to give access for my below example.

Ex:

I have Two reports(SH01 and SH02) in qvw.

Users:

User1

User2

User3

User4

I wanted to give access like below

User1 -  all reports(SH01 and SH02).

User2  and User3- first report(SH01).

User4 - second report(SH02)

How to achieve it? please help me.

[#2]

Hi Priya,

In Hidden script

Section Access; 

LOAD * INLINE [ 

ACCESS, USERID, PASSWORD, USERNAME 

ADMIN, USER1, user1, USER1 

USER, USER2, user2, USER2 

USER, USER3, user3, USER3

]; 

Section Application; 

SheetAccess: 

LOAD * INLINE [ 

USERNAME, SHEET1FLAG, SHEET2FLAG

USER1, 1,1

USER2, 1,0

USER3, 0,1

]; 

Enable Condition in Sheet1  SHEET1FLAG=1 similarly for Sheet2

[#3 · Accepted solution]

hi priya,

i will suggest you to give access as sheet level.

in object level you will face much problems.

you place two sheet-

in one sheet you put all object and in second put selected object.

Section Access; 

LOAD * INLINE [ 

ACCESS, USERID, PASSWORD, USERNAME  ,GROUP

ADMIN, USER1, user1, USER1  ,GROUP1

USER, USER2, user2, USER2  ,GROUP1

USER, USER3, user3, USER3,GROUP2

]; 

Section Application; 

LOAD * INLINE [ 

GROUP,SH01, SH02

GROUP1, 1,1

GROUP2, 1,0

]; 

in sheet properties you use = sum(SH01)>=1

                                                   = sum(SH02)>=1

Regards

Vimlesh

[mukesh24]

Hi,

Load following table in u r data model.

LOAD * INLINE [

QVUS, SHEET1, SHEET2

USER1, 1,1

USER2, 1,0

USER3, 1,0

USER3, 0,1

];

Use following expression in Sheet Properties --> General --> Conditional

only(if(QVUS=upper(OSUser()),SHEET1))>0

same condition for sheet2

only(if(QVUS=upper(OSUser()),SHEET2))>0

Regards,

Mukesh

[jagan]

Hi Priya,

Check this links below

Sheet level access

Sheet Level Access

Hope it helps you.

Regards,

Jagan.

[#6]

hi priya,

try like this.......

ALL SHOULD BE IN CAPS ONLY WHILE GIVING SECTION ACCESS TO USER

Section Access;

LOAD * INLINE [

ACCESS, USERID, PASSWORD, USERNAME

ADMIN, USER1, USER1 , USER1

USER, USER2, USER2  , USER2

USER, USER3, USER3, USER3

USER, USER4, USER4, USER4

];

Section Application;

LOAD * INLINE [

USERNAME,SH01, SH02

USER1  , 1,1

USER2  , 1,0

USER3 , 1,0

USER4, 0,1

];

in 1st sheet properties write condition "=SH01" or "=SHEETNAME"

      2nd sheet properties write condition "=SH02" or "=SHEETNAME"

[its_anandrjs]

Hi,

Go for Sheet level section access security, and implement the logic that way.

Regards

Anand