Section Access - Expanding of columns locks User accounts out

[#1]

Hi All,

I have setup Section acccess into a qwv without a problem and it works.

Now the customer has asked that different users logins must be filtered based on a sperate field.

so I added the new field(RESTRICTED NETWORK) into my Security.xls file and added the copy field to the fact table.

My problem is now that once I have re-loaded only the Admin users can login, all the previous USER accounts is locked out totally.

If I remove the (RESTRICTED NETWORK) field from my Hidden Script to not import the data the Section Access works fine again.

Regards

Jimmy

[#2]

Hi jimmybou,

Could you please upload your application?

Thanks,

Nima

[#3]

Hi,

It is too big to upload but will it help if I post the script?

Regards

[#4]

Hi,

Yes , it could be helpful too.

Thanks,

Nima

[#5]

Hi Nima,

Here is the Hidden Script which I started. Attached is also the PEM_Security.xls file, this is my first security setup I am trying.

Star is *;

Section Access;

SECURITY:

LOAD * INLINE [

    ACCESS, USERID, PASSWORD, RESTRICTED ADMINISTRATOR, RESTRICTED SCHEME, RESTRICTED NETWORK

    ADMIN, QBCON, Qu4qbc,

];

SECURITY:

LOAD [ACCESS],

     [USERID],

     [PASSWORD],

     [RESTRICTED ADMINISTRATOR],

     [RESTRICTED SCHEME],

     [RESTRICTED NETWORK]

     //COMMENT

FROM

$(zDataPath)\PEM_Security.xls

(biff, embedded labels, table is Users$);

Section Application;