Oracle Reports runtime: ROLE parameter

From: Kanny <paul_kan1_at_hotmail.com>
Date: 23 Jul 2002 04:26:09 -0700
Message-ID: <aeab02c7.0207230326.d38d363@posting.google.com>

Hello,

Can anyone help with this problem?

I'm trying to run an Oracle report using a command line like:

C:\Orant\Bin\rwrun60 REPORT='C:\Oracle\Runtime_Dev\my_report.rep' USERID='my_username/my_password_at_my_database' ROLE='my_role' DESFORMAT='PDF' DESTYPE='file' DESNAME='C:\temp\my_doc.pdf' PRINTJOB='no' PARAMFORM='no' BATCH='yes'

The idea is that 'my_username' has very limited database access but is granted 'my_role' to run the report.

But I get "REP-0342: Warning: Cannot set roles specified in the report."

Does the user 'my_username' already have to have the role 'my_role' granted? If so, what is the point of the ROLE parameter?

I've already read Oracle Note: 9972.1

Thanks Received on Tue Jul 23 2002 - 06:26:09 CDT