[DERBY-4161] SQL Roles - Clarify documentation regarding the SET ROLE

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.5.1.1
• Fix Version/s: 10.5.2.0, 10.6.1.0
• Component/s: Documentation
• Assignee: Camilla Haase
• Reporter: Tiago R. Espinha
• Created: 15/Apr/09 13:31
• Updated: 16/Jul/09 21:24
• Resolved: 08/May/09 14:20

Description

After discussing this issue on the mailing list, it has been agreed that the documentation regarding the usage of SQL roles needs to be clarified.

Namely, it should be clearer that a session does not have a role set by default and that as such, a SET ROLE must be issued to enable a specific role.

Further along the path, we may want to have the ability of setting a default role but for now and for the release of 10.5 this is the shortest and best course to follow.

Kim had already suggested an addition to the documentation on the list; maybe she'd like to take on this issue?

Issue Links

• is related to: DERBY-4162 SQL Roles - Add the possibility for a default role for each user