Security Access

[tracycrown]

Dear all

I had created following script but several problems encountered :

1. System asked for UserID but it did not ask for password.

2. System should allow Admin to access all Sheets, User C to access Sheet3 only but it allows User C to access all Sheets. 

Section Access;
LOAD * INLINE [
ACCESS, USERID, PASSWORD
Admin, Admin, admin
User, A, a
User, B, b
User, C, c
];

Section Application;
LOAD * INLINE [
USERID, SHEET
Admin, ALL
A, Sheet1
B, Sheet2
C, Sheet3
];

Thank You

Tracy

[hari8088]

Hi In Section application

Give like this

LOAD * INLINE [
USERID, [Sheet ID]
Admin,
A, SH01
B, SH02
C, SH03
];

Then make shore click "Scrict Exclution" in document properties

[marcus_sommer]

The reason for this behaviour is that there are no data which are connected with the section access - if you add one (like in the attachement) you will be queried for the password. Here you will find many informations about Section Access.

- Marcus

[rubenmarin]

Hi Tracy, in document properties (CTRL+ALT+D)-->'On Open' tab--> Check the 'Initial Data Reduction Based on Section Access'.

This will restrict the SHEET field values each user can see. And also it will start asking for password.

[MindaugasBacius]

The other way to restrict using the sheets are the conditions in Sheet properties.

[sasiparupudi1]

Hi

Please see the attached document.. hope this helps

Sasi