[DERBY-3488] Add functional (ie user level) tests for system privileges

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Test
• Assignee: Unassigned
• Reporter: Daniel John Debrunner
• Created: 01/Mar/08 00:40
• Updated: 25/Nov/09 16:37

Description

Having worked through committing a significant portion of patch12 from DERBY-2109 it seems that it contained no functional tests related to the functionality it is implementing. I'm basing this on the fact that all test code changes are applied and all pass with the functionality disabled.

So having tests that ensured:

• users with invalid authentication can not shut a network server down
• granting permissions (shutdown server, engine & create database) to specific principals works (and disallows principals without th permission)

is really key for a security feature.