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

Compare with Current View Page History

« Previous Version 5 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 as a script to run on Cornell from your DBeaver application:


     GRANT SELECT ON local_shared.vs_folio_physical_material_formats TO z_slm5;



Ask the user to confirm that he or she can see and use the table after you have granted permissions.



  • No labels