A script-enabled browser is required for this page to function properly.

Setting a database role

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:

  1. In the Object Navigator, double-click the Properties icon (the properties icon) for the report to display the Property Inspector.

  2. Under the Report node, set the Role Name property as defined by the database administrator in the database.

  3. (Optional) To set a Role Password, double-click the button in the Role Name value field to display the Set Role dialog box.

Usage notes:

Warning: Do not attempt to set the role in a PL/SQL trigger. The PL/SQL will not compile.

See also

About database roles