One of our users is trying to open some of his local databases but all are coming up with the you are not authorized error.
He can however, look at the ACL list and he IS listed in there. Even I cannot open the database as the administrator and the administrator is also listed in the acl (both have person-manager access). Even if I look at the effective access for that user he has Full Administrative Access.
I copied the database to my machine and tried opening it and it did. Then I removed him from the ACL and added him again but then I was locked out again!
I am stumped with this. It’s happening to all of his local databases.
I’ve just found out that if I close notes and reopen then I can open the files.
BUT…if I make a change like changing acl access to add another user or try to refresh the design of the database, then i get the same error until i relaunch notes.
I tried to look fr the Read Access List but I cannot even find the security tab. I assume the view properties is found by right clicking the database and choosing properties?
I’m not sure I can help your problem (which admittedly sounds a little weird - maybe something to do with the view being refreshed on first use?), but to look at restricted Access Lists, you need to be in Designer, with the view open. in the properties dialog, select the tab with the key on it.
Under “Who may use this view”, if “All readers and above” is NOT ticked, then the list will determine who can access the view, independently of the ACL (though not, of course, overriding the ACL).
Sounds like enforce-consistent-ACL property is set. You did not say whether you tried putting it on a server (that way the ACL would be fully honored). Locally, the ACL is somewhat disabled, except for replicas created with the above property set. In this case, only the creator of the local replica truly has rights.