Project

General

Profile

Download (1.63 KB)

Wiki » Sql-26-06-2024.sql

Bhanuchander Sannidhanam, 26/06/2024 08:04 PM

 
--insert into Sysorganization (Id,Code,Name,Description) values (1,'RSHA','RSHA','RSHA'),(2,'PWD','PWD','PWD')
--------------------------------------------------------------------------------------------------------------------------------
Added organization column in Sysuserdef table & Updated sysuserdef with the following query

--update sysuserdef set Organization = 1 where username like '%rsha%'
--update sysuserdef set Organization = 2 where username not like '%rsha%'
--------------------------------------------------------------------------------------------------------------------------------
Created a table named 'LKPTPIU' in NM Module for useraccess in the user creation section.
Create table LKPTPIU
(
Code nvarchar(50),
Description nvarchar(50)
)

Insert records in LKPTPIU table
insert into LKPTPIU (Code,Description) values (select distinct PIU,PIU from Linkmaster where PIU is not null)
--------------------------------------------------------------------------------------------------------------------------------
Added column in Linkmaster as "PIU" for user related access to RSHA data

Updated PIU column in Linkmaster with the data from RSHA (Agency column in Linkmaster)
--update Linkmaster set PIU = Agency where Agency = 'RSHA'
--------------------------------------------------------------------------------------------------------------------------------
Updated sysconfiguration (sysadmin) UserAccess field with the value 'Linkmaster.PIU'

Created Home2 module for RSHA users
(1-1/5)