[DERBY-3722] Add circularity check for the GRANT role statement

• Type: Sub-task
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 10.5.1.1
• Component/s: SQL
• Bug behavior facts: Security
• Assignee: Dag H. Wanvik
• Reporter: Dag H. Wanvik
• Created: 14/Jun/08 22:32
• Updated: 30/Jun/09 00:14
• Resolved: 22/Jun/08 01:10

Description

When a role is granted to another role (with the GRANT <role> statement), we need to check that the grant relation does not give rise to a circularity. This is described in Section 12.5, Syntax rule 1 of ISO/IEC 9075-2 2003.