diff options
| author |   Christopher Lott (cl778h) <clott@research.att.com> | 2017-08-04 12:03:58 -0400 |
|---|---|---|
| committer | Christopher Lott (cl778h) <clott@research.att.com> | 2017-08-04 12:04:46 -0400 |
| commit | 0afd2766d9a16672be6b9970b0b6693affccc4b4 (patch) | |
| tree | 85cebe7b6e0774f837b11d2633a2c7207ef07670 | |
| parent | 5ef2a3f67c8f1330e3fe4edcfeedfcbc5a4b9f98 (diff) | |
Revise demo user orgUserId to match Portal.
An exact match enables single sign on at the Portal, recognized at app.
Change-Id: I102d0c64397decf5982c475dd7f56ca7504cba90
Signed-off-by: Christopher Lott (cl778h) <clott@research.att.com>
| -rw-r--r-- | dcae_dmaapbc_webapp/dbca-os/db-scripts/dbca-dml-mysql-1707-os.sql | 7 |
1 files changed, 0 insertions, 7 deletions
diff --git a/dcae_dmaapbc_webapp/dbca-os/db-scripts/dbca-dml-mysql-1707-os.sql b/dcae_dmaapbc_webapp/dbca-os/db-scripts/dbca-dml-mysql-1707-os.sql index e36b1d6..5bd6014 100644 --- a/dcae_dmaapbc_webapp/dbca-os/db-scripts/dbca-dml-mysql-1707-os.sql +++ b/dcae_dmaapbc_webapp/dbca-os/db-scripts/dbca-dml-mysql-1707-os.sql @@ -442,13 +442,6 @@ Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (16,'menu_data_router' Insert into fn_role_function (ROLE_ID,FUNCTION_CD) values (16,'menu_message_router'); -- fn_user --- This row defines a superuser which is accepted by login_extern.htm --- The superuser entry is enabled in this checked-in version, ACTIVE = Y, -Insert into fn_user - (USER_ID,ORG_ID,MANAGER_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,PHONE,FAX,CELLULAR,EMAIL,ADDRESS_ID,ALERT_METHOD_CD,HRID,ORG_USER_ID,ORG_CODE,LOGIN_ID,LOGIN_PWD,LAST_LOGIN_DATE,ACTIVE_YN,CREATED_ID,CREATED_DATE,MODIFIED_ID,MODIFIED_DATE,IS_INTERNAL_YN,ADDRESS_LINE_1,ADDRESS_LINE_2,CITY,STATE_CD,ZIP_CODE,COUNTRY_CD,LOCATION_CLLI,ORG_MANAGER_USERID,COMPANY,DEPARTMENT_NAME,JOB_TITLE,TIMEZONE,DEPARTMENT,BUSINESS_UNIT,BUSINESS_UNIT_NAME,COST_CENTER,FIN_LOC_CODE,SILO_STATUS) - values - (1,null,null,'Super',null,'User','973-236-0000',null,null,'user@openecomp.org',null,null,null,'su1234',null,'demo','demo123456!',str_to_date('21-AUG-14','%d-%M-%Y'),'Y',null,str_to_date('15-DEC-05','%d-%M-%Y'),1,str_to_date('21-AUG-14','%d-%M-%Y'),'N',null,null,null,'NJ',null,'US',null,null,null,null,null,10,null,null,null,null,null,null) - ; -- This row defines a demo user to match the demo user in Portal for ONAP. Insert into fn_user (USER_ID,ORG_ID,MANAGER_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,PHONE,FAX,CELLULAR,EMAIL,ADDRESS_ID,ALERT_METHOD_CD,HRID,ORG_USER_ID,ORG_CODE,LOGIN_ID,LOGIN_PWD,LAST_LOGIN_DATE,ACTIVE_YN,CREATED_ID,CREATED_DATE,MODIFIED_ID,MODIFIED_DATE,IS_INTERNAL_YN,ADDRESS_LINE_1,ADDRESS_LINE_2,CITY,STATE_CD,ZIP_CODE,COUNTRY_CD,LOCATION_CLLI,ORG_MANAGER_USERID,COMPANY,DEPARTMENT_NAME,JOB_TITLE,TIMEZONE,DEPARTMENT,BUSINESS_UNIT,BUSINESS_UNIT_NAME,COST_CENTER,FIN_LOC_CODE,SILO_STATUS) |