Before beginning this procedure, verify that the database administrator has created the role, granted privileges to the role, and granted the role to approved end users. Refer to your Oracle Application Developer's Guide for more information.
To set a database role for a report:
In
the Object Navigator, double-click (the properties icon)
for the report to display the Property Inspector.
Under the Report node, set the Role Name property as defined by the database administrator in the database.
(Optional) To set a Role Password, double-click the button in the Role Name value field to display the Set Role dialog box.
The role settings in the report are overridden
if you specify a role using the command line with Reports Runtime (rwrun
).
You can set only one role for a report. To set multiple roles, you need to set a role to which the other roles have been granted.
Warning: Do not attempt to set the role in a PL/SQL trigger. The PL/SQL will not compile.
Copyright © 1984, 2005, Oracle. All rights reserved.