By default concurrent manager jobs are run under the APPS user. Is it possible to configure it to run as another user? I'd like to be able to isolate some of my stored procedures.
默认情况下,并发管理器作业在APPS用户下运行。是否可以将其配置为以另一个用户身份运行?我希望能够隔离我的一些存储过程。
1 个解决方案
#1
1
Not aware of any standard way, but you could code your concurrent request to handle that. E.g. copy fnd_concurrent_requests, then in the "real" concurrent program insert into your custom_fnd_concurrent_requests "select * from fnd_concurrent_requests". Create dbms_job or something to poll your custom table, and get it to call your "real" program - make sure you fnd_global.initialize with the user, resp, and appl from fnd_concurrent_requests, and direct output to your own files using utl_file rather than fnd_file.
不知道任何标准方式,但您可以编写并发请求来处理它。例如。复制fnd_concurrent_requests,然后在“real”并发程序中插入custom_fnd_concurrent_requests“select * from fnd_concurrent_requests”。创建dbms_job或其他东西以轮询您的自定义表,并让它调用您的“真实”程序 - 确保您使用fnd_concurrent_requests中的用户,resp和appl fnd_global.initialize,并使用utl_file而不是fnd_file将输出直接输出到您自己的文件。
#1
1
Not aware of any standard way, but you could code your concurrent request to handle that. E.g. copy fnd_concurrent_requests, then in the "real" concurrent program insert into your custom_fnd_concurrent_requests "select * from fnd_concurrent_requests". Create dbms_job or something to poll your custom table, and get it to call your "real" program - make sure you fnd_global.initialize with the user, resp, and appl from fnd_concurrent_requests, and direct output to your own files using utl_file rather than fnd_file.
不知道任何标准方式,但您可以编写并发请求来处理它。例如。复制fnd_concurrent_requests,然后在“real”并发程序中插入custom_fnd_concurrent_requests“select * from fnd_concurrent_requests”。创建dbms_job或其他东西以轮询您的自定义表,并让它调用您的“真实”程序 - 确保您使用fnd_concurrent_requests中的用户,resp和appl fnd_global.initialize,并使用utl_file而不是fnd_file将输出直接输出到您自己的文件。