BGRS Reference ZenDesk Ticket: 4943961

Description: User is requesting access for their backup to be able to run reports in Relodialgoue for all Clients and all divisions. 

Solution:

Login to the IRP DB 10.139.88.101 select XA DB

-- Confirms if SKola has any access already.  In this case the user has no access
select * from XAUserDataAccess where userid='skola'

Submit DBCR with the below details.  Note the UserIDIKeyValue, ClientID and Devision will all be provided by the requestor in the ticket 

use xa
Begin tran
Insert into xa.dbo.XAUserDataAccess
(Userid,KeyValue,Update_dt,Opid,ClientID,Division)values ('skola','ALLCLIENTS',GETDATE(),'slumbania','ALL','ALL')
Commit tran