How to grant access to SSIS

 https://dba.stackexchange.com/questions/77320/how-do-i-grant-the-privilege-of-connecting-to-ssis 

Databricks Audit

 

How to Install Oracle Client 19c

 How to Install Oracle Client 19c

https://www.youtube.com/watch?v=DuPFO6Eh0aM

PC>properties>advanced system settings>Environment Variables>New System Variables>ORACLE_HOME>paste directory

set path add oracle directory\bin

set TNS_ADMIN = ORACLE_HOME\network\admin

How to get when a user was added on an ad group

 $username    = "dexter.soreta"            

$userobj     = (Get-ADUser $username -Properties memberof).memberof

$dc          = (Get-ADDomainController).name   

$membershipreport = 

foreach($group in $userobj){

    Get-ADReplicationAttributeMetadata $group -Server $dc -ShowAllLinkedValues |             

    Where-Object {

        $_.AttributeName -eq 'member' -and             

        $_.AttributeValue -eq $userobj.DistinguishedName

    } |            

    Select-Object FirstOriginatingCreateTime, Object, AttributeValue   

}

$membershipreport |

Sort-Object FirstOriginatingCreateTime -Descending |

export-csv "MembershipReport.csv" -NoTypeInformation

Import-Module ActiveDirectory            

            

$username = "janitor"            

$userobj  = Get-ADUser $username            

            

Get-ADUser $userobj.DistinguishedName -Properties memberOf |            

 Select-Object -ExpandProperty memberOf |            

 ForEach-Object {            

    Get-ADReplicationAttributeMetadata $_ -Server localhost -ShowAllLinkedValues |             

      Where-Object {$_.AttributeName -eq 'member' -and             

      $_.AttributeValue -eq $userobj.DistinguishedName} |            

      Select-Object FirstOriginatingCreateTime, Object, AttributeValue            

    } | Sort-Object FirstOriginatingCreateTime -Descending | Out-GridView

source: https://community.spiceworks.com/t/how-to-check-timestamp-of-user-added-to-certain-ad-group/965173/3

Windows Application not showing up on search

 https://www.lifewire.com/fix-windows-10-search-4176188

Oracle Password Complexity function

 CREATE OR REPLACE function SYS.ora_dex_verify_function

 ( username     varchar2,

   password     varchar2,

   old_password varchar2)

 return boolean IS

   differ  integer;

   lang    varchar2(512);

   message varchar2(512);

   ret     number;

   last_change sys.user$.ptime%type; --DAV4635 minimum_age

   minimum_age number :=1;--DAV4635 minimum_age

begin

   -- Get the cur context lang and use utl_lms for messages- Bug 22730089

   lang := sys_context('userenv','lang');

   lang := substr(lang,1,instr(lang,'_')-1);

   if not ora_complexity_check(password, chars => 8, uppercase => 1,

                           lowercase => 1, digit => 1, special => 1) then

      return(false);

   end if;

   -- Check if the password differs from the previous password by at least

   -- 8 characters

   if old_password is not null then

      differ := ora_string_distance(old_password, password);

      if differ < 4 then

         ret := utl_lms.get_message(28211, 'RDBMS', 'ORA', lang, message);

         raise_application_error(-20000, utl_lms.format_message(message, 'four'));

      end if;

   --DAV4635 minimum_age

  select ptime into last_change from sys.user$ where name=username;

   if sysdate - last_change < minimum_age then

raise_application_error(-20010, 'Password changed too soon');

return(false);

   --DAV4635 minimum_age

    end if;

  end if;

   return(true);

end;

/

How to increase event log retention on windows

Configuring Security Event Log Size and Retention Settings

Security event log size and retention settings can be configured in each computer or configured via a GPO to all target computers.

Local Configuration

1. Open Run (Start -> Run), type eventvwr.msc
2. Right click "Security" log(Event Viewer -> Windows Logs -> Security log) and select "Properties"
3. Configure "Maximum log size" as defined below in the table
   
4. Configure "When maximum event log size is reached" retention method for security log to “Overwrite Events As Needed”
   

GPO Configuration

1. Open GPMC
2. Edit the corresponding GPO (FIM on DomainControllers, FIM on Member Servers)
3. Navigate to Computer Configuration → Policies →  Windows Settings → Security Settings →  Event Log
4. Configure "Maximum security log" size as defined below
5. Configure "Retention method for security log" to “Overwrite Events As Needed”
   

Recommended Security Log Size

Role	OS of the target computer	Log size(MB)
Domain Controller	Windows Server 2003	307
Domain Controller	Windows Server 2008 and above	1048
File Server	Windows Server 2003	307
File Server	Windows Server 2008 and above	4194
Member Server	Windows Server 2003	307
Member Server	Windows Server 2008 and above	1048
Workstation	Window XP	307
Workstation	Windows Vista and above	1048