What someone can do with a workbook comes from three things, checked in this order:
- Their site role sets a ceiling. A Viewer can never edit in the browser or download full data, whatever a rule says; an Explorer can't publish. Creator and Explorer (can publish) can do everything.
- Permission rules on the project or item, for a group or a user. Each rule picks a template (View, Explore, Publish, Administer, Denied) and can set single capabilities to Allowed or Denied.
- Between rules: a rule for the user wins over group rules; among groups, Denied wins over Allowed; anything unspecified is not allowed.
A project's content permissions are either Locked to the project, so every item follows the project's rules, or Customizable, so items keep their own. Give rules to groups, not to people.
This practice site models the main capabilities; the real one has a few more, such as comments. Effective permissions in the dialog shows what one person can do and why.
Denied on one capability for one group beats Allowed from another.