Advertisement
Guest User

Untitled

a guest
Jun 6th, 2017
589
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.88 KB | None | 0 0
  1. Insert into USER_PROFILE (ID,TYPE) values ('1','Admin');
  2. Insert into USER_PROFILE (ID,TYPE) values ('2','DBA');
  3. Insert into USER_PROFILE (ID,TYPE) values ('3','USER');
  4. Insert into USER_PROFILE (ID,TYPE) values ('4','ACR');
  5. Insert into USER_PROFILE (ID,TYPE) values ('5','VAL');
  6.  
  7.  
  8. 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');
  9. 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');
  10. Insert into APP_USER (ID,EMAIL,FIRST_NAME,LAST_NAME,PASSWORD,SSO_ID) values ('2','dev@mail.comm','Dev','Arena','dev','dev');
  11. Insert into APP_USER (ID,EMAIL,FIRST_NAME,LAST_NAME,PASSWORD,SSO_ID) values ('3','acr@mail.comm','AnalisisYControl','Riesgos','acr','acr');
  12. Insert into APP_USER (ID,EMAIL,FIRST_NAME,LAST_NAME,PASSWORD,SSO_ID) values ('4','val@mail.comm','Valoracion','Depositaria','val','val');
  13.  
  14. -- user1 -> Admin
  15. Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('1','1');
  16.  
  17. -- dev -> Admin | DBA | USER | ACR | VAL
  18. Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('2','1');
  19. Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('2','2');
  20. Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('2','3');
  21. Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('2','4');
  22. Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('2','5');
  23.  
  24. -- acr -> USER | ACR
  25. Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('3','3');
  26. Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('3','4');
  27.  
  28. -- val -> USER | VAL
  29. Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('4','3');
  30. Insert into APP_USER_USER_PROFILE (USER_ID,USER_PROFILE_ID) values ('4','5');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement