Granting user access to staging tables
Follow these steps to grant or revoke the authorization to staging tables.
Procedure
- From any window within the CAE Browser Client select Activity Browser > Application Menu > Query Tuning > Manage Staging Tables.
-
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.
- Click Edit.
- Click Next.
- Click Next.
-
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.
-
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.
- Click Next.
- Review the DDL.
- Click Execute SQL.