Statistics
| Branch: | Revision:

m2u-upass-admin / DBScript / insert_ib_role.sql @ 88:2ab7c8154b54

History | View | Annotate | Download (771 Bytes)

1
Insert into IB_ROLE (ROLE_ID,ROLE_NAME,ROLE_DESCRIPTION,ROLE_CREATED_BY,ROLE_UPDATED_BY,ROLE_CREATION_DATE,ROLE_UPDATED_DATE) values (1,'Retail User','Retail User',1,1,to_timestamp(),GETDATE());
2
Insert into IB_ROLE (ROLE_ID,ROLE_NAME,ROLE_DESCRIPTION,ROLE_CREATED_BY,ROLE_UPDATED_BY,ROLE_CREATION_DATE,ROLE_UPDATED_DATE) values (2,'Approver all','Approver all',1,1,to_timestamp(),GETDATE());
3
Insert into IB_ROLE (ROLE_ID,ROLE_NAME,ROLE_DESCRIPTION,ROLE_CREATED_BY,ROLE_UPDATED_BY,ROLE_CREATION_DATE,ROLE_UPDATED_DATE) values (3,'Initiator','Initiator',1,1,to_timestamp(),GETDATE());
4
Insert into IB_ROLE (ROLE_ID,ROLE_NAME,ROLE_DESCRIPTION,ROLE_CREATED_BY,ROLE_UPDATED_BY,ROLE_CREATION_DATE,ROLE_UPDATED_DATE) values (4,'Approver','Approver',1,1,to_timestamp(),GETDATE());