On 05/08/2025 21:29, Rick Hillegas wrote:
I haven't explored this in any depth, but you might be able to update the foreign keys in a row-deleting procedure which runs with DEFINER rights. This would require you to run with authentication and authorization turned on. In normal operation, the application would be run by an ordinary user with limited rights, NOT by the DBO. The following script shows the basic mechanics of this. You might want to read the section titled "Configuring fine-grained user authorization" in the Derby Security Guide.
Ooh, ah. Looks complicated but I'll have a look. Many thanks. -- John English -- This email has been checked for viruses by AVG antivirus software. www.avg.com
