I am able to login to redshift using "AGINITY workbench for Redshift" and can see the databases but when trying to expand database under Object Browser to view the tables within it, i get error :
Error Reading Schema List : permission denied for relation pg_user.
I know that on granting the access to pg_user this error goes off, but i would like to know the reason why we need to grant users access to pg_user to view "Object Browser"
Please help me know the system tables access required to view Object Browser?
I dont see this error in SQL-Workbench/j Database explorer. It works find without pg_user access.
Please sign in to leave a comment.