how t checkk pii column in db

 EXEC sp_msforeachDB 'USE [sn_baxter]

SELECT db_name() as [DB], 

object_name(o.object_id) AS [Object], 

c.name AS [Column]

FROM sys.columns c join sys.objects o ON c.object_id = o.object_id 

WHERE o.type IN (''U'',''V'') /* tables and views */

AND (c.name like ''%mail%''

OR c.name like ''%first%name%''

OR c.name like ''%last%name%''

OR c.name like ''%birth%''

OR c.name like ''%sex%''

OR c.name like ''%address%''

OR c.name like ''%phone%''

OR c.name like ''%social%''

OR c.name like ''%ssn%''

OR c.name like ''%gender%'')

AND db_name() NOT IN (''msdb'',''tempdb'',''master'')'

Comments

Post a Comment

Popular posts from this blog

java chapter11 practice question on abstruct class and interfaces

  /* Chapter 11 - Practise Set 1... Create an abstract class Pen with methods Write () and refill 1) as abstract methods 2... Use the Pen Class from Q1 to create a Concrete class fountain Pen with additional method change Nibl) 3...Create a class Monkey with jump () and bitel) methods. Create a class Human which inherits this Monkey class and implements Basic Animalinterface with eati) and sleep methods. 4.... Greate a class Telephone with ring() liftus and disconnect ( methods as abstract methods Create another class Smart Telephone and demonstratepolymorphism 5.....Demonstrate polymorphism Msing monkey class from Quess 3. 6.......Create an Interface TV Remote and use it to inheritanother Interface Smart Tv Remote 7...... Create a Class Tv which implements Tv Remote interface qsn 6 */ package com.company ; //programe 1 abstract class Pen { abstract void Write (); abstract void Refill (); } //programe 2 class FountainPen extends Pen { void Writ
Read more

java practice set 8

  questions: /* 1. Create a class Employee with the following properties and methods: Salary (property) (int) getSalary (method returning int) name (property) (String) getName (method returning String) setName (method changing name) 2. Create a class cellphone with methods to print “ringing…”, “vibrating…”, etc. 3. Create a class Square with a method to initialize its side, calculating area, perimeter etc. 4. Create a class Rectangle & problem 3. 5. Create a class TommyVecetti for Rockstar Games capable of hitting (print hitting…), running, firing, etc. 6. Repeat problem 4 for a circle. */ answers package com.company; class Employee{ int salary; String name; public int getSalary(){ return salary; } public String getName(){ return name; } public void setName(String n){ name = n; } } class CellPhone{ public void ring(){ System.out.print
Read more

new stored procidure with interval and frequery code

 CREATE procedure  [dbo].[SP_Baxter_CSAT]                                                                                                             AS                                                            BEGIN            DECLARE @ExtractIdOut INT                                                                   DECLARE @EndDt DATETIME2                                 DECLARE @runDate DATETIME2                                 DECLARE @RecordCount INT = 0                                                                 DECLARE @ProcedureName SYSNAME = OBJECT_NAME(@@PROCID)                                              DECLARE @intErrorCode INT                                                                 Declare @returnCode int = 0                                                                 DECLARE @ExtractProcessControlId UniqueIdentifier                                                                 SET NOCOUNT ON;                              BEGIN TRY           --Log the
Read more