[TRAFODION-3074] Failed to register or unregister user when database security is not enabled

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Component/s: sql-security
• Assignee: Roberta Marton
• Reporter: Roberta Marton
• Created: 17/May/18 16:02
• Updated: 15/Sep/18 07:31
• Resolved: 21/May/18 16:10

Description

When authorization is not enabled, unable to register or unregister users.  This is a regression.

register user:

 *** ERROR[1001] An internal error occurred in module ../sqlcomp/CmpSeabaseDDLauth.cpp on line 380. Details(CmpSeabaseDDLauth::getUniqueAuthID failed, ran out of available IDs).

Once the register user issue was resolved, unable to unregister user:

 

>>unregister user testuser1;

. . . 

• • • ERROR[8448] Unable to access Hbase interface. Call to ExpHbaseInterface::scanOpen returned error HBASE_OPEN_ERROR(-704). Cause: org.apache.hadoop.hbase.TableNotFoundException: TRAFODION.PRIVMGR_MD.COMPONENT_PRIVILEGES

 

. . .

• • • ERROR[1001] An internal error occurred in module

../sqlcomp/CmpSeabaseDDLauth.cpp on line 2080. Details(Unable to retrieve

dependent information CmpSeabaseDDLuser::unregisterUser).