I there any way to limit access to Redshift external schemas by table level?

Question

I am working currently in a project where we are using Redshift and Spectrum to manage some external schemas with the data stored at S3.

In order to have access to an external schema the user must belong to a group with the USAGE permission over this external schema but it seems that, with the USAGE grant this user will be able see and query ALL the external schema tables.

What I would like to do is to only grant SELECT permission for a particular table, not the whole schema.

Is that possible? I have checked the AWS docs and try different things but as the external tables have a particular nature I have not found any useful information yet.

Thanks in advance.

Answer 1

You can't do that directly on the External tables.

[Removed the earlier approach of using views as that would not solve it]