[SENTRY-2259] SQL CONSTRAINT name for user privilege is too long for Oracle 11.2

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 2.1.0
• Fix Version/s: 2.2.0
• Component/s: Sentry
• Assignee: Na Li
• Reporter: Na Li
• Created: 06/Jun/18 16:46
• Updated: 02/Jan/20 17:08
• Resolved: 29/Jun/18 17:33

Description

Prior to Oracle version 12.2, identifiers are not allowed to exceed 30 characters in length
Names must be from 1 to 30 bytes long with these exceptions:
Names of databases are limited to 8 bytes.
Names of database links can be as long as 128 bytes.

The following index name is 32 bytes, and cause exception "ORA-00972: identifier is too long" on oracle DB 11.2.

SENTRY_USER_DB_PRIVILEGE_MAP_PK
SEN_USR_DB_PRV_MAP_SN_DB_PRV_FK

ALTER TABLE SENTRY_USER_DB_PRIVILEGE_MAP
ADD CONSTRAINT SENTRY_USER_DB_PRIVILEGE_MAP_PK PRIMARY KEY (USER_ID,DB_PRIVILEGE_ID);

ALTER TABLE SENTRY_USER_DB_PRIVILEGE_MAP
   ADD CONSTRAINT SEN_USR_DB_PRV_MAP_SN_DB_PRV_FK 
   FOREIGN KEY (DB_PRIVILEGE_ID) REFERENCES SENTRY_DB_PRIVILEGE(DB_PRIVILEGE_ID);

Need to change the constrain name to be smaller than 30 characters

Issue Links

• links to: Review Link for this case