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
| 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");