My Oracle Support Banner

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 to [Release Oracle10g to 10gr2]
Generic UNIX


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 or rwservlet, not 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.

[root@repteam oracle]# id
uid=0(root) gid=0(root) groups=0(root),1(bin),2(daemon),3(sys),4(adm),6(disk),10(wheel)

[root@<machine> oracle]# 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.