Statistics
| Branch: | Revision:

m2u-upass-admin / DBScript / insert_ib_role.sql @ 90:a033e3985176

History | View | Annotate | Download (771 Bytes)

1 0:ea666cc7880e hadi 
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());