Skip to main content
  • EN
  • Home
  • Forums
  • FME Form
  • General
  • How to run exec and grant command in fme like "exec dbms_stats.gather_table_stats(‘Schema_name’, ‘Table_name’)" and "GRANT SELECT ON table_Name TO public"
How to run exec and grant command in fme like "exec dbms_stats.gather_table_stats(‘Schema_name’, ‘Table_name’)" and "GRANT SELECT ON table_Name TO public"

Hi @rohit​ 

Have you tried running the SQLStatement using SQLCreator or SQLExecutor transformers?

Here is an article The SQLCreator and SQLExecutor Transformers that will be a good start.

 

Hi @rohit​ 

Have you tried running the SQLStatement using SQLCreator or SQLExecutor transformers?

Here is an article The SQLCreator and SQLExecutor Transformers that will be a good start.

 

yes, it ran successfully but didnot make any stats or even grant to public

Reply


Community Stats

30,171
Posts
114,537
Replies
37,834
Members
Terms & ConditionsCookie 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.