How to Set File Ownership of Report Output to Something Other than Oracle User Using Reports Server
(Doc ID 745328.1)
Last updated on OCTOBER 03, 2023
Applies to:Oracle Reports Developer - Version 10.1.2.0.2 to 10.1.2.3 [Release Oracle10g to 10gr2]
There is a need to create an Oracle Report output file as the OS owner who ran the report instead of the user who installed or started the Reports Server.
By default, when a report is being run using Reports Server (via rwclient.sh or rwservlet, not rwrun.sh) and using destype=file, the report output file will be generated with the ownership of the user who started the Reports Server.
In the following example, the Reports Server was started as the oracle account and the test.rdf report is run as root user.
uid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel)
[root@<machine> oracle]# rwclient.sh server=rep_test report=test.rdf destype=file desformat=pdf desname=/tmp/test.pdf userid=<userid> authid=<orcladmin>/*****
[root@<machine> oracle]# ls -l /tmp/test.pdf
-rw-rw-r-- 1 oracle oracle 42429 Oct 24 15:50 /tmp/test.pdf
Notice that the ownership of the report output file is set to oracle account instead of root. This is because the Reports Server and Reports Engine process were started as the oracle user.
How can you generate an output file with ownership set to the user who ran report?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document