There are a few ways to go about this:
1. Create a persona for these users, and provide them access to these assets by create Metadata and a Data policy.
You can specify the tables in the connection on which you want to enforce the policy when setting the policy.
2. You might also think about assigning these assets a suitable classification if they are publicly accessible or business-critical assets. Then, to manage access, you can establish a Purpose and create the necessary access policies.