Page History

...

*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.