Project

General

Profile

Actions

Task #264

open

Refactor ACC and SYS tables

Added by Ondřej Kopr over 7 years ago. Updated over 3 years ago.

Status:
New
Priority:
Low
Assignee:
Radek Tomiška
Category:
Database
Target version:
-
Start date:
01/09/2017
Due date:
% Done:

0%

Estimated time:
Owner:

Description

After test oracle database it was found some problem with identifier.
Oracle reserved words: https://docs.oracle.com/cd/B19306_01/em.102/b40103/app_oracle_reserved_words.htm there is UID

In tables:
acc_account - ORA-00904: : invalid identifier
sys_role_system_attribute - ORA-00904: : invalid identifier
sys_role_system_attribute_a - ORA-00904: : invalid identifier
sys_schema_attribute_handling - ORA-00904: : invalid identifier
sys_system_entity - ORA-00904: : invalid identifier

is used reserved word UID, please change this word to some else, thank you.

Bonus:
In table sys_schema_attribute_handling_a, is too long identifier.


Related issues

Related to IdStory Identity Manager - Task #262: Test provisioning on Oracle SQLClosedOndřej Kopr01/09/2017

Actions
Actions

Also available in: Atom PDF