grant select on products, products_series, series, item_contributors, contributors, packs, mags, mag_issues, keywords, subject_categories to nobody;
grant select, update, insert, delete on asset_derivatives, assets, assets_products, assets_series, asset_kinds, mime_types, assets_keywords, assets_subject_categories to nobody;

grant select on products, products_series, series, item_contributors, contributors, packs, mags, mag_issues, keywords, subject_categories to scholastic;
grant select, update, insert, delete on asset_derivatives, assets, assets_products, assets_series, asset_kinds, mime_types, assets_keywords, assets_subject_categories to scholastic;

grant select on products, products_series, series, item_contributors, contributors, packs, mags, mag_issues, keywords, subject_categories to root;
grant select, update, insert, delete on asset_derivatives, assets, assets_products, assets_series, asset_kinds, mime_types, assets_keywords, assets_subject_categories to root;