Question
Need help getting the where clause to work in the FeatureReader. The where clause is a select on SYS.USER_PRIVILEGES table to limit the number of tables accessed. SELECT OWNER, TABLE_NAME FROM SYS.table_privileges WHERE GRANTEE='GIS_VIEWER'
Need help getting the where clause to work in the FeatureReader. The where clause is a select on SYS.USER_PRIVILEGES table to limit the number of tables accessed. SELECT OWNER, TABLE_NAME FROM SYS.table_privileges WHERE GRANTEE='GIS_VIEWER'
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.
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.
Hi,
I'd consider using the SQLExecutor instead, I find it much simpler for complex queries.
David
I’ve also tried the SQLCreator and SQLExecutor with no luck. The fmw sees the Where Clause and reads it but when it comes to the FeatureReader ArcSDE objects that are selected in the Table List are always pushed through.
I’ve tried adding the SQLExecutor after the FeatureReader but I no longer see the Metadata extracted by the FeatureReader which is what we are trying to export out of the ArcSDE Geodatabase in Oracle in order to publish it. The reason we would like to do this based on permissions is because there is data in this database that cannot be viewed by some users.
Thank you,
Hi,
try the following to build a separate list of feature class names using a SQLCreator and then passing them into the FeatureReader, something like this:
SQLCreator with:
SELECT OWNER || '.' || TABLE_NAME AS "FC_NAME" FROM SYS.table_privileges WHERE GRANTEE='GIS_VIEWER'
Expose the attribute FC_NAME on the SQLCreator.
Append a ListBuilder, just leave as-is.
Append a ListConcatenator, set it up like this:
The configure the FeatureReader as follows:
Hopefully this works.
David
Workbench and SQLPlus do not lke the syntax of the sql and no table names are selected from the SYS.table_privileges table.
I think it's a bug with the FeatureReader in FME Server.
FeatureReader where clause debug from Workbench:
UWIWellbore<space>=<space><apos><at>Value<openparen>UWIWellbore<closeparen><apos>
FeatureReader where clause debug from Server:
UWIWellbore<space>=ValueUWIWellbore