# Connection permissions on Redshift Connector, Table Selector

**URL:** <https://forum.knime.com/t/connection-permissions-on-redshift-connector-table-selector/28969>\
**Category:** KNIME Extensions\
**Tags:** aws\
**Created:** [November 24, 2020, 5:57pm UTC](https://forum.knime.com/t/connection-permissions-on-redshift-connector-table-selector/28969 "2020-11-24T17:57:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![msweetnam](https://forum-cdn.knime.com/letter_avatar_proxy/v4/letter/m/d6d6ee/32.png) [@msweetnam](https://forum.knime.com/u/msweetnam)\
**Post date:** [November 24, 2020, 5:57pm UTC](https://forum.knime.com/t/connection-permissions-on-redshift-connector-table-selector/28969/1 "2020-11-24T17:57:51Z")

</div>

I created a Redshift Connector and successfully connected. However, when i connect a Table selector to it, i can see the tables but get an error “Error fetching columns” (as shown in the image). When i hover over to see the tooltip, it says “… permission denied for schema: xxx”. However I use the same connection information with my SQL dev tool and i can see and work with the schema with no problems… What’s going on?

 ![image](https://forum-cdn.knime.com/uploads/default/original/3X/c/7/c79ac5d5014c85b41fc61ba5a197ba2e7fd1beb7.png)

---

<div class="post-metadata">

**Author:** ![Iris](https://forum-cdn.knime.com/user_avatar/forum.knime.com/iris/32/14_2.png) [@Iris](https://forum.knime.com/u/Iris)\
**Post date:** [November 27, 2020, 4:47pm UTC](https://forum.knime.com/t/connection-permissions-on-redshift-connector-table-selector/28969/2 "2020-11-27T16:47:35Z")

</div>

Hi @msweetnam

currently you need to have permissions to list all buckets to use this functionality. We have a open ticket for this which we just fixed for our december release. It sounds like this is the same problem you are experiencing.

It would be great if you could test this with our nightly build, than we can be 100% sure we fixed this before the release goes out. Would you do this?