Change Workflow Administrator through Query

We can change the workflow administrator without use sysadmin through command prompt. This query is working fine and change the workflow administrator


Select Statement for identified Current Administrator
-----------------------------------------------------------------
[furqanapps@ebstest ~]$ source dirapps/apps/apps_st/appl/APPSTEST_ebstest.env  [furqanapps@ebstest ~]$ sqlplus apps/apps

SQL*Plus: Release 10.1.0.5.0 - Production on Wed Jun 19 09:09:35 2019

Copyright (c) 1982, 2005, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL> SELECT * FROM WF_RESOURCES WF
WHERE WF.NAME IN ('WF_ADMIN', 'WF_ADMIN_ROLE');

Update New Administrator
---------------------------------
SQL> UPDATE WF_RESOURCES SET TEXT = 'FURQAN'
WHERE NAME = 'WF_ADMIN_ROLE';

SQL> COMMIT;


Source: R&D