Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Insert into USER_PROFILE (ID,TYPE) values ('1','Admin');
- Insert into USER_PROFILE (ID,TYPE) values ('2','DBA');
- Insert into USER_PROFILE (ID,TYPE) values ('3','USER');
- Insert into USER_PROFILE (ID,TYPE) values ('4','ACR');
- Insert into USER_PROFILE (ID,TYPE) values ('5','VAL');
- Insert into APP_USER (ID,EMAIL,FIRST_NAME,LAST_NAME,PASSWORD,SSO_ID) values ('1','user@mail.comm','user_name','user_last_name','user','user1');
- Insert into APP_USER (ID,EMAIL,FIRST_NAME,LAST_NAME,PASSWORD,SSO_ID) values ('5','samy@xyz.comm','Sam','Smith','$2a$10$4eqIF5s/ewJwHK1p8lqlFOEm2QIA0S8g6./Lok.pQxqcxaBZYChRm','sam');
- Insert into APP_USER (ID,EMAIL,FIRST_NAME,LAST_NAME,PASSWORD,SSO_ID) values ('2','dev@mail.comm','Dev','Arena','dev','dev');
- Insert into APP_USER (ID,EMAIL,FIRST_NAME,LAST_NAME,PASSWORD,SSO_ID) values ('3','acr@mail.comm','AnalisisYControl','Riesgos','acr','acr');
- Insert into APP_USER (ID,EMAIL,FIRST_NAME,LAST_NAME,PASSWORD,SSO_ID) values ('4','val@mail.comm','Valoracion','Depositaria','val','val');
- -- user1 -> Admin
- Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('1','1');
- -- dev -> Admin | DBA | USER | ACR | VAL
- Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('2','1');
- Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('2','2');
- Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('2','3');
- Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('2','4');
- Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('2','5');
- -- acr -> USER | ACR
- Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('3','3');
- Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('3','4');
- -- val -> USER | VAL
- Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('4','3');
- Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('4','5');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement