Forum Discussion
The maximum access possible is a good way of describing this.
It will give the user the highest level permissions for every record the user has access to, regardless of what level of access the user should have for that role.
So:
If you make a Record Owner Role, so users can create records
Then make a Limited Access Role, so users can view limited data on records they did not create
The User now has Record Owner permissions to all records they have access to through either Role, regardless of any restrictions.
Quickbase gives the User Record Owner permissions on all of the records they have access to through the Limited Access Role. So basically, if you want a user to be able to create records, and have any kind of limited view to records they did not create on the same table, this is not possible through permissions.
Once you grant a user access to a record, regardless of what restrictions you put on that access, as soon as you give them another level of access to that same table, it will grant them the highest level of permissions, regardless of whether the Role applies to the particular record or not.
It will give the user the highest level permissions for every record the user has access to, regardless of what level of access the user should have for that role.
So:
If you make a Record Owner Role, so users can create records
Then make a Limited Access Role, so users can view limited data on records they did not create
The User now has Record Owner permissions to all records they have access to through either Role, regardless of any restrictions.
Quickbase gives the User Record Owner permissions on all of the records they have access to through the Limited Access Role. So basically, if you want a user to be able to create records, and have any kind of limited view to records they did not create on the same table, this is not possible through permissions.
Once you grant a user access to a record, regardless of what restrictions you put on that access, as soon as you give them another level of access to that same table, it will grant them the highest level of permissions, regardless of whether the Role applies to the particular record or not.