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.


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

>--(--+-"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.  


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.


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

Copyright© 2018 HCL Technologies Limited