As far as I know it is not possible to specify detailed user access levels other than on the level of schemas. So granting read/copy access to specific tables or even structures specifically for individual users is not possible, at least not in a mySQL-based system (correct me if I'm wrong).
In a scenario where you may want to share a subset of structures and data for a particular project with an external collaborator, is there a way to set this up without having to export or create a separate database for this subset? Is it possible to create a separate schema within the same database (to which then the collaborator could get access) and link this to the structures and data in another schema that contains all structures and assay data for all projects, and somehow 'earmark' the structures and data that the collaborator would be allowed to see?
Any tips appreciated!