[DERBY-3084] CREATE SCHEMA in refman does not contain material on restrictions in sqlAuthorization mode

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.2.1.6, 10.2.2.0, 10.3.1.4
• Fix Version/s: 10.4.1.3
• Component/s: Documentation
• Urgency: Normal
• Assignee: Camilla Haase
• Reporter: Dag H. Wanvik
• Created: 20/Sep/07 23:46
• Updated: 12/Oct/07 19:59
• Resolved: 12/Oct/07 09:12

Description

The CREATE SCHEMA statement is subject to access control when running in sqlAuthorization mode.
Only the database owner can create a schema with name different from the current user name and
only the the database owner can specify AUTHORIZATION <user>, with a user name other than the
current user name, cf comment in StatementSchemaPermission#check, ca line 86.

These restrictions are not described in http://db.apache.org/derby/docs/dev/ref/rrefsqlj31580.html.