- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2026 02:40 PM
I've been off the tools for a while, so this is probably a dumb question...
Is there a simple way to get a full list of all the tables that a particular user appears in?
E.g., if there is a user John Doe, is it possible to return a list of all the tables that store data related specifically to John Doe? If so, how?
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2026 02:42 PM
I don't think there is a direct way to do this. However, you can use the Schema Map to see where the User table is being used, which might be helpful.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2026 02:46 PM
ahoy @Simon Hendery,
perhaps database view could help but it would require lots of manual configurations.
Example of usage of Database view: How to get values from multiple tables in a single report (data visualisation)
Perhaps the easiest way would be to write a script for given tables to do the checks - it can be either fix script and/or scheduled job..
Let me sleep for that and perhaps I will have ab etter ideas in the morning :))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2026 02:42 PM
I don't think there is a direct way to do this. However, you can use the Schema Map to see where the User table is being used, which might be helpful.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2026 02:46 PM
ahoy @Simon Hendery,
perhaps database view could help but it would require lots of manual configurations.
Example of usage of Database view: How to get values from multiple tables in a single report (data visualisation)
Perhaps the easiest way would be to write a script for given tables to do the checks - it can be either fix script and/or scheduled job..
Let me sleep for that and perhaps I will have ab etter ideas in the morning :))
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2026 02:55 PM
Thanks @glideFather
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-04-2026 03:00 PM
Meanwhile, once again ...
What a f**king debacle.