Link two bases content in lookup

Is it possible to link with the lookup features the content of a table that is in a different base?

Could you help describe the usecase for this please. Technically its possible to do this - but once there are like access control comes into the picture. This can get tricky. So please provide the access control you imagine as well.

In nocodb base, we’re managing a materials database across several tables, each categorized by material types. Additionally, we have in another base set of tables for construction objects, such as walls and slabs. the goal goal is to create a direct linkage between materials and object types. To safeguard material specifications, we’ll restrict editing access to authorized users only. Similarly, for construction object tables, we’ll employ selective permissions and tailor views