Skip to main content
Archived

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

Related products:Integrations
  • March 2, 2017
  • 1 reply
  • 37 views
michaelfitzpatr
Contributor
Forum|alt.badge.img+1

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.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
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+10
  • ciarabContributor
  • Contributor
  • March 3, 2017

Just hit this similar problem today for Ingres database connection!

Community Stats

32,655
Posts
123,930
Replies
41,067
Members
Terms & ConditionsAccessibility statement
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.