*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
...
*reporting team user accounts: z_slm5, z_jl41, z_lm15, z_np55, z_vp25, z_ama8, z_jmp8
...
| Schema Name | Schema Description | Permissions |
|---|---|---|
| local_openautomation | This schema is a sandbox for all users who want to publish a file to a local schemafor internal use by the Automation Team. | r/w z_metadbuser_cornell user accountr/w any other user accounts - REMOVE |
| local_automationcore | This schema is for internal use by the Automation Reporting Team. | r/w z_metadbuser_cornell user accountr/w any other user accounts - REMOVE |
local_ corederived | This schema is for internal use by the Reporting Team. | r/ wo z_metadbuser_cornell user account r/w any otherreporting team user accounts -REMOVE |
| local_digpres | This schema is used by the HathiTrust team. | r/w z_metadbuser_cornell user account |
| local_eusage | This schema is used for EBSCO consolidation report data. | r/o z_metadbuser_cornell user account r/w any other user accounts -REMOVEz_slm5, z_vp25 |
| local_hathitrust | This schema is used internally by the HathiTrust team. | r/w z_metadbuser_cornell user account |
| local_open | This schema is a sandbox for all users who want to publish a file to a local schema. | r/w any other user accounts - REMOVEz_metadbuser_cornell user account |
| 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_ sharedstatic | 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 schemaaccounts |
| local_statistics | This schema is for internal use by the Assessment and Planning team. | r/o z_metadbuser_cornell user account r/w z_lm15slm5, z_slm5, z_vp25 - KEEP*set as r/w for z_lm15, z_slm5, z_vp25 as default_vp25 |
Reporting Team Members and the Local Static Schema
Reporting Team members create files in the local_static schema that are used by report queries to show additional information in the query results, such as Cornell-specific bibliographic format, library location names, etc. To create these files, reporting team members use their z_netid user accounts because these accounts have "read-write" permissions to create files in the local_static schema. General reporting users are connecting to the Metadb reporting database with the z_metadbuser_cornell user account, which has "read-only" permissions to the files in the local_static schema. This means that queries that use the tables that reporting team members publish to the local_static schema, such as "folio_physical_material_formats" and "adc_location_translation_table," will allow z_metadbuser_cornell account users to "read" the data in those tables. There is no need to assign permissions to the z_metadbuser_cornell account to see these tables as they are published because the read-only permission for z_metadbuser_cornell is part of the design of the local_static schema.
How to Set Permissions on files used in Local Schemas
...
*Please note that if you replace or update the table, you will need to reset these permissions.
Reporting Team Members and the Local Shared Schema
Reporting Team members create files in the local_shared schema that are used by report queries to show additional information in the query results, such as Cornell-specific bibliographic format, library location names, etc. To create these files, reporting team members use their z_netid user accounts because these accounts have "read-write" permissions to create files in the local_shared schema. General reporting users are connecting to the Metadb reporting database with the z_metadbuser_cornell user account, which has "read-only" permissions to the files in the local_shared schema. This means that queries that use the tables that reporting team members publish to the local_shared schema, such as "folio_physical_material_formats" and "adc_location_translation_table," will allow z_metadbuser_cornell account users to "read" the data in those tables. There is no need to assign permissions to the z_metadbuser_cornell account to see these tables as they are published because the read-only permission for z_metadbuser_cornell is part of the design of the local_shared schema.ALTER DEFAULT PRIVILEGES for user z_slm5 IN SCHEMA local_statistics GRANT SELECT ON TABLES TO z_lm15, z_vp25;
ALTER DEFAULT PRIVILEGES for user z_slm5 IN SCHEMA local_statistics GRANT SELECT, INSERT, UPDATE, DELETE ON TABLES TO z_lm15, z_vp25;
ALTER DEFAULT PRIVILEGES for user z_slm5 IN SCHEMA local_statistics GRANT USAGE ON SEQUENCES TO z_lm15, z_vp25;
ALTER DEFAULT PRIVILEGES for user z_slm5 IN SCHEMA local_statistics GRANT SELECT ON TABLES TO z_metadbuser_cornell;