I'm not entirely sure, but I don't think so.
Actually there are two questions:
- Yes you can, using for example local groups or a Custom directory (QV EE only). However, you cannot mix AD/Windows accounts with Custom groups !
- Yes, you can using fixed local code/data or external authentication/authorization or any mix of those. See Marcus' answer for all details.
May be possible using Section Access,
Say for example,
Excel has Group list, password and Sheet\Data Access level
Dashboard home sheet should prompt for user group and password, based on the group and password, make the respective sheet\objects visible.
Access to Access point should be done through AD or LDAP.
An option is to have a list of restricted Users managed in a flat file (i.e. Excel) and use association to org hierarchy. Below is an example:
Then, set document even triggers OnOpen to set OSUser() to the following:
1) a variable - can be used in IF condition or conditional logic for show/hide of Sheet/Object
2) a Select Field - i.e. %OpID and lock if sett to All sheets and objects