DataGrip doesn't show objects under schemas for SELECT-ONLY User

I created some lower-privileged users in redshift and when logging under their credentials they can see the database and shemas but no tables or views under the schemas. I tried "forget schema" and "synchronize" - no luck yet.

this is in DataGrip version 2017.1.5, Postgres Driver version 42.1.1

 

the users are granted:

  • usage to schema
  • select on all tables and views in schema

such low-priv user can see all tables and columns with this query:

SELECT *
FROM pg_table_def
WHERE schemaname = 'awsma'
ORDER BY tablename;

is there some other / extra permissions that DataGrip relies on to get the list of objects and attributes displayed?

thanks in advance!

 

0
2 comments
Avatar
Permanently deleted user

SOLUTION: was to use the Redshift JDBC driver - then DataGrip started to show all the objects visible to SELECT-ONLY user!

 

0

Hi,

Try DataGrip 2017.2 EAP with better Redshift support https://www.jetbrains.com/datagrip/nextversion/

Thank you.

0

Please sign in to leave a comment.