Re: Oracle Reports runtime: ROLE parameter

From: Kanny <paul_kan1_at_hotmail.com>
Date: 24 Jul 2002 05:42:43 -0700
Message-ID: <aeab02c7.0207240442.421f7a70@posting.google.com>

Thanks Andy, this works.

Here's a summary of the solution for anyone else who maybe interested:

Create user MY_USER and grant CREATE SESSION privilege. Create role MY_ROLE and grant to user MY_USER. Set DEFAULT = "NO" for role MY_ROLE (on user MY_USER). Grant required privileges to role MY_ROLE.

On the command line for RWRUN60, specify the following parameters:

USERID='MY_USER/MY_PASSWORD_at_MY_DATABASE' ROLE='MY_ROLE' The user MY_ROLE then gets the necessary privileges from MY_ROLE for the duration of the report. Received on Wed Jul 24 2002 - 07:42:43 CDT