...
| 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 any other user accounts - REMOVE |
| local_automation | This schema is for internal use by the Automation Team. | r/w z_metadbuser_cornell user account r/w any other user accounts - REMOVE |
| local_core | This schema is for internal use by the Reporting Team. | r/w z_metadbuser_cornell user accountr/w any other user accounts -REMOVE |
| local_digpres | This schema is used by the HathiTrust team. | r/w z_metadbuser_cornell user account r/w any other user accounts -REMOVE |
| local_hathitrust | This schema is used internally by the HathiTrust team. | r/w z_metadbuser_cornell user account r/w any other user accounts - REMOVE |
| 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 - KEEP *set as r/w for z_slm5, z_jl41 as default for schema |
| 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 *set as r/w for reporting team accounts as default for schema accounts |
| 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*set as r/w for z_lm15, z_slm5, z_vp25 as defaultvp25 |
How to Set Permissions on files used in Local Schemas
...