Re: Oracle Reports runtime: ROLE parameter

Paul

I've not used oracle reports in a long while but I think the problem is more likely with the roles. I'd take an educated guess that the problem is that you need to grant the role to the user but to make the role non-default i.e. such it is not activated by default (alter user <username> default role all except <theRoleToDisable>. I'd guess that the ROLE='my_role' parameter tells Oracle reports to issue the alter user <username> default role <my_role> or similar to enable the role.

Can anyone confirm my suspicions ? or am I barking up the wrong tree ?

"Kanny" <paul_kan1_at_hotmail.com> wrote in message news:aeab02c7.0207230326.d38d363_at_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 - 07:48:13 CDT