[HIVE-8083] Authorization DDLs should not enforce hive identifier syntax for user or group

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.13.0, 0.13.1
• Fix Version/s: 0.14.0
• Component/s: SQL, SQLStandardAuthorization
• Release Note: The user name in the grant and revoke statements may be optionally surrounded by backtick characters (`) irrespective of the hive.support.quoted.identifiers setting.
• Assignee: Prasad Suresh Mujumdar
• Reporter: Prasad Suresh Mujumdar
• Created: 12/Sep/14 21:44
• Updated: 13/Nov/14 19:40
• Resolved: 19/Sep/14 05:02

Description

The compiler expects principals (user, group and role) as hive identifiers for authorization DDLs. The user and group are entities that belong to external namespace and we can't expect those to follow hive identifier syntax rules. For example, a userid or group can contain '-' which is not allowed by compiler.

Issue Links

• links to: Review #25595