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!
请先登录再写评论。
SOLUTION: was to use the Redshift JDBC driver - then DataGrip started to show all the objects visible to SELECT-ONLY user!
Hi,
Try DataGrip 2017.2 EAP with better Redshift support https://www.jetbrains.com/datagrip/nextversion/
Thank you.