You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 7 Next »


To give other users permission to see and use a table you have imported or created in a local schema, you need to grant that user access to the new table. To do so, you can issue a command to alter the table permissions as a query in a DBeaver session connected to Metadb. Here is an example:


To grant the user z_slm5 access to the table vs_folio_physical_material_formats in the local_shared schema on Metadb, you would issue this command:


     GRANT SELECT ON local_shared.vs_folio_physical_material_formats TO z_slm5;



Re-issue the command for each user if there are multiple users to whom you need to grant access. Ask the user(s) to confirm seeing the table after you have granted permissions.



  • No labels