...
| Schema Name | Schema Description | Permissions |
|---|---|---|
| local_open | This schema is a sandbox for all users who want to publish a file to a local schema. | r/w z_metadbuser_cornell user account r/w reporting team any other user accounts - RemoveREMOVE |
| local_automation | This schema is for internal use by the Automation Team. | r/w z_metadbuser_cornell user account r/w reporting team any other user accounts - RemoveREMOVE |
| local_core | This schema is for internal use by the Reporting Team. | r/w z_metadbuser_cornell user account r/w reporting team any other user accounts - RemoveREMOVE |
| local_digpres | This schema is used by the HathiTrust team. | r/w z_metadbuser_cornell user account r/w reporting team any other user accounts - RemoveREMOVE |
| local_hathitrust | This schema is used internally by the HathiTrust team. | r/w z_metadbuser_cornell user account r/w reporting team any other user accounts - RemoveREMOVE |
| local_protected | This schema is used to store tables with protected data that is used internally by the Reporting Team. | r/o reporting team user accounts r/w z_slm5, z_jl41 jl41 - KEEP |
| local_shared | This schema is used to store local tables that are in queries used by all reporting users. All users can read the files here, but only reporting team members can post files here. | r/o z_metadbuser_cornell user account r/w reporting team user accounts *- KEEP |
| local_statistics | This schema is for internal use by the Assessment and Planning team. | r/o z_metadbuser_cornell user account r/w z_lm15, z_slm5, z_vp25 - KEEP |
How to Set Permissions on files used in Local Schemas
...