Section access

[#1]

Hi all,

Under document properties I enabled "Initial Data reduction based on Section Access."

Now as expected when a user opens the document he will get prompted with username and password.

I tried different version with all upperletter etc but can't get in...someone know why?

Any hint much appreciated...

Thx L

[#2]

Hi all,

Ok, I got this halfway going.....

I found some sample load script in the help and created this...

section access;

load * inline

[UserID,DEPT,Access

John,FINANCE,Admin

ANN,IS,Admin

Peter,SALES,User

Ben,TECH,User ];

section application;

star is *;

load * inline

[DEPT,CostCenter

FINANCE,*

IS,5020

SALES,5030

TECH,5040 ] ;

So when I log in as Peter I only see the costcenter 5030 which is correct based on the tables above...

Now, ideally I can login with windows credentials and I was hoping when I add my windows account to the inline table in the access section above it would work, but I still have to type my account into the user id box coming up when I open the document. Why is this? How can I make it to "see" my windwos account and pass it through?

I also have some buttons on a sheet which I'd like to be visible or not depending on the user. I tried adding a second table for the users button relationship within the access section but it didn't accept it. How would that work?

Any hint much appreciated.

Best Regards

Ludwig

[prieper]

User NTNAME instead of USERID as header of the field

HTH
Peter

[amien]

with section access and section application .. what will the result be if a selection is made?

uses will only see the costcenter 5030 .. but will there be an additional data reduction somehow if a selection is made?

with selection i mean if i open a qvw from the server, make a selection, close the application .. and then open the qvw again .. the selection is still there. will that effect the data reduce option?

[#5]

Thx Peter, that did it. Ludwig

[#6]

Hi Amien,

My answers below in <>

with section access and section application .. what will the result be if a selection is made?

<it don't expect it to be any different than without section. As the current log in user is concerned he just sees what 's avialable to him based on his security specs>

uses will only see the costcenter 5030 .. but will there be an additional data reduction somehow if a selection is made?

<I need to check this out how this behaves in detail and if sums only include costcenters a specifc user has access to but I'd very surprised if it didn't work. Keep you posted..>

with selection i mean if i open a qvw from the server, make a selection, close the application .. and then open the qvw again .. the selection is still there. will that effect the data reduce option?

<I would expect that it does not matter if you close the file and reopen it. It should still apply the same data and reductions>

Thx

Ludwig

[#7]

Hi Ludwig,

I'm working around the same issue as you have, and I'd like to ask if you have a qvw where the Section Access is used.

I've been trying to create a script using it, but didn't have success.

Tks a lot!

Sheila