default user in section access

[omid5ive]

hi

i have a dashboard with many users and sheet. in my case each user can see on e or more sheet that he/she has its prmission.

my users store in some table and i create my section access with below code:

Section Access;

LOAD

    upper(SAMAccountFullName) as NTNAME,

    'ADMIN' as ACCESS;

SQL SELECT *

FROM "K:\Database1.accdb".Users;

my problem is:
when some user open this document that he/she has not permission to see non of sheet i want to see a sheet with ' no access ' text

what should i do?

[Peter_Cammaert]

I guess that your sheet control is based on variables or fields that contain "permissive" values when a user is allowed to see a particular sheet? Create a sheet that only shows up when none of these values are set to show a sheet.

This won't work if Section Access blocks a user from the start, for example by not being listed in the permission table or by completely reducing the data model and having "Strict Exclusion" enabled. In that case you may need to add a default "Everyone else" user.

[omid5ive]

hi
exactly i have a table with many users and my problem is when some one want to see this dashboard that his/her user is not in users table what will be see!!
in current situation he will see default message that " you have not access ..."
how can i create "Everyone else" user?

[Peter_Cammaert]

End your Section Access table with an entry carrying an asterisk ( * ) in the NTNAME field.

Be careful with this kind of patched security, as you will be giving document access to everyone. Although you say that you won't show anything to "the others", other settings or configuration options may provide backdoors in certain situations.