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
siennaatsafe
ciarab
michaelfitzpatr
  • siennaatsafe
    siennaatsafe
  • ciarab
    ciarab
  • michaelfitzpatr
    michaelfitzpatr

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
  • Contributor
  • March 3, 2017

Just hit this similar problem today for Ingres database connection!


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