By using AWS re:Post, you agree to the Terms of Use

I cannot seem to create schema-level permissions in Babelfish

0

Why can't I grant permissions on a schema in Babelfish 2.1.1 or earlier?

asked 2 months ago40 views
1 Answer
0
Accepted Answer

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.

answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions