In Odoo, database tables are called Models. Examples include:
- Customers and Suppliers
- Sales Orders
- Sales Order Lines
- Purchase Orders
- Purchase Order Lines
Users must be granted permission to a Model in order to use it. This is done by adding users to User Access Groups, which are then granted permission for one or all of the following actions:
- Write (update)
Note that Read access is required in order to have any access!
Various combinations are possible, including
- Read and Write (but not create and delete)
- Read, Write and Create but not delete
Model Access can be further limited by Record Rules
It’s possible to view and maintain Model Access either from the User Access Group or the Model.
From the Model it is in the “Access Rights” tab:
Summary of access
In Odoo 13 you can also view the Access Rights (and Record Rules) for a user from a series of “Smart Buttons” on the User Profile.
- List of User Access Groups (lists all the different types of Access Group)
- List of Access Rights
- List of Record Rules
These can be useful for troubleshooting.
List of Access Rights
Click on the Access Rights “smart button” to display a list of all the Model Access for this user (this will come from multiple access groups).
Use Filter or “Group By” to view information for one or more Models (database tables).
Remember that this access may be limited by Record Rules