set sql tracing user argument: Control tracing for users (SQL administration API)

Use the set sql tracing user argument with the admin() or task() function to change SQL tracing for users.

Syntax

Read syntax diagramSkip visual syntax diagram
>>-EXECUTE FUNCTION--+-admin-+---------------------------------->
                     '-task--'   

>--(--+-"set sql tracing user add"--,--"user_name"----+--)--;--><
      +-"set sql tracing user clear"------------------+         
      +-"set sql tracing user list"-------------------+         
      '-"set sql tracing user remove"--,--"user_name"-'         

Element Description Key Considerations
user_name The name of the user.  

Usage

Use the set sql tracing user add argument to specify tracing for a specific user.

Use the set sql tracing user clear argument to remove all users from the tracing list.

Use the set sql tracing user list argument to list the users that are being traced.

Use the set sql tracing user remove argument to remove a single user from the list of users being traced.

Example

The following example stops tracing SQL statements for the user named fred:
EXECUTE FUNCTION task("set sql tracing user remove","fred");

Copyright© 2019 HCL Technologies Limited