Granting user access to staging tables

Follow these steps to grant or revoke the authorization to staging tables.

Procedure

  1. From any window within the CAE Browser Client select Activity Browser > Application Menu > Query Tuning > Manage Staging Tables.
  2. Highlight the connection for which you want to modify user access.
    Note: Staging tables can hold potentially sensitive information (such as dynamic SQL text and host variables). Grant a user access to staging tables only if it is acceptable for the user to access that information.
  3. Click Edit.
  4. Click Next.
  5. Click Next.
  6. Select Grant or Revoke Authorization on Staging Tables.
    If you have existing tables and want to modify the authorization, then clear the Recreate Staging Tables check box.
  7. Click Next.
    • To add an authorization, click Add Row. Type the authorization ID of the user you want to define access for in the Authorization ID field.
    • To remove an authorization, highlight the corresponding row in the authorization list and click Remove Row.
    • To grant authority, select YES in the corresponding list (SELECT, INSERT, UPDATE, or DELETE). To revoke authority, select NO in the corresponding list.
  8. Click Next.
  9. Review the DDL.
  10. Click Execute SQL.