BGRS ZenDesk Reference: 1691261
Description: This request is to create a new GOC client department in iZone. You will receive the clientID, department names in English and French which to create in the database as well as permissions to add client users.
In this example:
ClientID: PAC & PSIC
Client Users:
les.jones
Kathleen.Mills
catherine.molina
Department Names:
cooriginal: Pacific Economic Development Canada
dfrench: Développement économique Canada pour le Pacifique
cooriginal: Pacific Econ. Dev. Canada
dfrench: Dév économique Pacifique
Process:
Apply to IRP DB
10.139.88.101
--Script1 Add client user access to the 2 new client ID's PAC & PSIC
use xa
Begin tran
Insert into xa.dbo.XAUserDataAccess (Userid,KeyValue,Update_dt,Opid,ClientID,Division)values ('les.jones','GOC',GETDATE(),'slumbania','PAC','ALL')
Insert into xa.dbo.XAUserDataAccess (Userid,KeyValue,Update_dt,Opid,ClientID,Division)values ('les.jones','GOC',GETDATE(),'slumbania','PSIC','ALL')
Insert into xa.dbo.XAUserDataAccess (Userid,KeyValue,Update_dt,Opid,ClientID,Division)values ('Kathleen.Mills','GOC',GETDATE(),'slumbania','PAC','ALL')
Insert into xa.dbo.XAUserDataAccess (Userid,KeyValue,Update_dt,Opid,ClientID,Division)values ('Kathleen.Mills','GOC',GETDATE(),'slumbania','PSIC','ALL')
Insert into xa.dbo.XAUserDataAccess (Userid,KeyValue,Update_dt,Opid,ClientID,Division)values ('catherine.molina','GOC',GETDATE(),'slumbania','PAC','ALL')
Insert into xa.dbo.XAUserDataAccess (Userid,KeyValue,Update_dt,Opid,ClientID,Division)values ('catherine.molina','GOC',GETDATE(),'slumbania','PSIC','ALL')
if @@ERROR > 0 or @@ROWCOUNT <> 6
BEGIN
ROLLBACK TRAN
RETURN
END
Commit tran
--Script2 Inserts the department name in English and French into strings table
USE irp
Begin tran
insert into strings (coriginal, cfrench, moduleID, createDate, update_dt,opid) values ('Pacific Economic Development Canada', 'Développement économique Canada pour le Pacifique', 'ALL', GETDATE(), GETDATE(),'slumbania')
insert into strings (coriginal, cfrench, moduleID, createDate, update_dt,opid) values ('Pacific Econ. Dev. Canada', 'Dév économique Pacifique', 'ALL', GETDATE(), GETDATE(),'slumbania')
insert into strings (coriginal, cfrench, moduleID, createDate, update_dt,opid) values ('Prairies Economic Development Canada', 'Développement économique Canada pour les Prairies', 'ALL', GETDATE(), GETDATE(),'slumbania')
insert into strings (coriginal, cfrench, moduleID, createDate, update_dt,opid) values ('Prairies Econ. Dev Canada', 'Dév économique pour les Prairies', 'ALL', GETDATE(), GETDATE(),'slumbania')
IF @@ERROR <> 0 or @@rowcount <> 4
BEGIN
ROLLBACK TRAN
RETURN
END
Commit tran
-
-Script3 Insert access rights userscr to include scr_name
use irp
begin tran
Insert into userscr (userid, scr_name, security, userresp, update_dt, opid, lchange_no) values('1447', 'CSAPPRREQUEST', 8, '#', GETDATE(), 'slumbania', 0)
Insert into userscr (userid, scr_name, security, userresp, update_dt, opid, lchange_no) values('1447', 'CSFILEAUDIT', 8, '#', GETDATE(), 'slumbania', 0)
Insert into userscr (userid, scr_name, security, userresp, update_dt, opid, lchange_no) values('1447', 'CSQUICKVIEW', 8, '#', GETDATE(), 'slumbania', 0)
IF @@ERROR <> 0 or @@rowcount <> 3
BEGIN
ROLLBACK TRAN
RETURN
END
Commit tran