Contents tagged with audit

• Audit Users logging in using "sa" or service accounts

  Tags: SQL Server, audit, login, logon, xml, email, mail

  Thursday, July 4, 2019 11:58:47 PM

  No Comments

  source: https://www.sqlservercentral.com/scripts/audit-users-logging-in-using-sa-or-service-accountsIF OBJECT_ID ('AuditSqlLogins') IS NOT NULL DROP TABLE AuditSqlLogins

  GO

  CREATE TABLE … more

• Oracle Basic Auditing

  Tags: Oracle, audit, auditing, sessions

  Thursday, June 7, 2018 4:43:37 PM

  No Comments

  selectto_number(substr(dbms_session.unique_session_id,1,4),'XXXX') as mysid,  sys_context('USERENV','SID') as my_current_session, sys_context('USERENV','SESSIONID') as my_audsid,sysdate as now, case … more