Please check updates for the latest version of Babelfish. As of July 2022, Babelfish version 2.1.1 does not have a way to grant permissions to the schema level. For now, the best practice is to create a database role like db_reader and then add your users to that role. Then, you can do the grant select statements for each table in your schema.
How do I see execution plans or optimize queries in Babelfish?Accepted Answer
I cannot seem to create schema-level permissions in BabelfishAccepted Answer
I am considering Babelfish and I'm curious about HIPAAAccepted Answerasked 3 months ago
How do I move an Entity Framework or EF Core app with Babelfish?asked 4 months ago
Should I use Compass or SCT for a Babelfish assessment?Accepted Answer
Where can I find Babelfish release notes or recent features?Accepted Answer
Redshift Datashare: Grant CREATE DATASHARE permissions to usersAccepted Answerasked 4 months ago
Does Babelfish support table partitioning via CREATE PARTITION?Accepted Answer
Does Babelfish support XML? How can I use XML?
Does Aurora Babelfish support Aurora Serverless?Accepted Answer