[TRAFODION-1595] Privilege manager tables missing from HBase

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: sql-cmu, sql-security
• Assignee: Unassigned
• Reporter: Roberta Marton
• Created: 06/Nov/15 17:45
• Updated: 04/Feb/16 00:32
• Resolved: 04/Feb/16 00:32

Description

The user had enabled security which creates a schema called "PRIVMGR_MD" and also creates several tables in the schema. As part of initializing security writes information into these tables.

Later, the user tries to create a role and HBase returns an error that one of the privilege manager tables, ROLE_USAGE was not found. At this time, it was noticed that all the privilege manager tables existed in the Trafodion metadata but non of the existed in HBase. It is unknown what happened to the tables.

The privilege manager tables were removed, security enabled and everything worked fine.