Skip to main content
Archived

Add 'rolename' as a parameter option for Postgresql in 'Database Connections'

Related products:Integrations
  • March 2, 2017
  • 1 reply
  • 1 view
hodsen96
  • hodsen96
    hodsen96
michaelfitzpatr
Contributor

Current functionality only permits connecting to Postgresql/PostGIS as a user. However the user may need to connect using a 'rolename' in order to carry out certain actions within a schema.

Scenario:

  • A user belongs to rolename: "data_readers"
  • They want to read data form schema: "the_data"
  • Schema "the_data" only permits 'SELECT' for rolename "data_readers". Individual users do not have 'SELECT' privileges on the schema
  • In this scenario FME cannot be used to read from schema "the_data"

For Postgresql and probably other database connections.

<strong>This post is closed to further activity.</strong><br /> It may be a question with a best answer, an implemented idea, or just a post needing no comment.<br /> If you have a follow-up or related question, please <a href="https://community.safe.com/topic/new">post a new question or idea</a>.<br /> If there is a genuine update to be made, please contact us and request that the post is reopened.

1 reply

ciarab
Contributor
Forum|alt.badge.img+9
  • ciarabContributor
  • Contributor
  • March 3, 2017

Just hit this similar problem today for Ingres database connection!

Helpful Members This Week

Community Stats

31,483
Posts
119,357
Replies
39,102
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.