Closed

Data at REST ( Encrypting Data at the column level)

I'm working on a small assignment

Requirements are as follows

I have a SQL server 2016 table in which i have (ID, APP_ID, App_Name , P_Name, Date_Processed, and Encrypted_Data_Row) columns

Table structure:

USE [MasterInvDB]

GO

/****** Object: Table [dbo].[MasterInv] Script Date: 7/31/2020 4:31:15 PM ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

CREATE TABLE [dbo].[MasterInv](

[ID] [int] NOT NULL,

[APP_ID] [int] NOT NULL,

[App_Name] [varchar](30) NOT NULL,

[P_Name] [varchar](30) NOT NULL,

[Date_Processed] [datetime] NULL,

[Encrypted_Data_Row] [varbinary](max) NULL,

PRIMARY KEY CLUSTERED

(

[ID] ASC

)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON,ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]

) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO

I get XML file from 15 unique applications and each application has its own PGP or public/private keys.

Sample XML.

<ns0:MasterRec xmlns:ns0="[login to view URL]">

<AppID>101</AppID>

<App_Name>CTMS</App_Name>

<P_Name>XORISXC</P_Name>

<Date_Processed>07312020</Date_Processed>

</ns0:MasterRec>\

Requirement is we have to encrypt the xml using the application specific key and insert to Encrypted_Data_Row column. ID column is auto generated , AppID, App_Name, P_Name, Date_Processed should be taken from the XML and insert to the table unencrypted before encrypting the XML and insert to Encrypted_Data_Row column.

If required you can create lookup tables to store the keys.

we have SQL Server 2016 and .net framework 4.6 with VS 2015 environment.

I'm looking for a SQL Stored procedure or a function for both encryption and decryption.

I want the best solution which can scale up or down in future

I can provide 2 PGP keys for 2 applications respectively.

I need clear explanation

Please let me know so that i can share the keys with passphrase for testing or you can create your own keys.

Skills: XML, Microsoft SQL Server, SQL

See more: forex data testing open source, copy column selected data excel macro, usb data transfer customer requirement management, column level encryption sql server 2016, column level encryption servicenow, sql server table encryption, column level encryption mysql, sql server column encryption best practice, tde vs column level encryption, sql server column encryption performance, field level encryption, java code level data mirroring, entry level data entry home, edmonton entry level data entry, computer project level data dictionary, services karachi data entry solution capture services, block level data replication, macro loop column add data list, kernel level keylogger testing, wesite security testing solution india

About the Employer:
( 0 reviews ) Guilderland, United States

Project ID: #26819781

3 freelancers are bidding on average $27 for this job

TechPretty1

Hello I have read project description and sql [login to view URL] I can help you do this assignment. Actually i have a team which has web,windows,Android,/IOS In-C#,SQL,ASP.Net ,SQl,XML.★★I'll provide lowest price with quality w More

$30 USD in 1 day
(1 Review)
1.0
afnanahmad0

Hi, So you are looking for an SP or a function which should do your task. Similarly you want your encryption should be done within store procedure or a function. Will you be passing XML as a parameter to the st More

$30 USD in 2 days
(0 Reviews)
0.0
muhammadEng

I understand this query sir. This task is very quick for me and I will do it perfectly. Just text me so I will start working to solve this query. Its only my responsibility to solve this problem for you sir.

$20 USD in 1 day
(0 Reviews)
0.0