dba_userSqlList
Retrieve SQL queries executed by a specific user or all users within a specified number of days. Optionally materialize results as a volatile table for further analysis.
Instructions
Get SQL run by a user in the last number of days. Leave user_name empty for all users.
Arguments: user_name - User name filter. Leave empty or omit for all users. no_days - Number of days to look back persist - If True, materializes result as a volatile table and returns table name
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| persist | No | If True, materializes result as a volatile table and returns table name | |
| user_name | No | User name filter. Leave empty or omit for all users. | |
| no_days | No | Number of days to look back |