Skip to content

Instantly share code, notes, and snippets.

@oehrlis

oehrlis/CMU_demo.md Secret

Created September 26, 2018 17:35
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save oehrlis/742bf1cabbedf116344b11dc595a92dd to your computer and use it in GitHub Desktop.
Save oehrlis/742bf1cabbedf116344b11dc595a92dd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
CMU_demo.md

Demos Oracle 18c New Security Features

A couple of demo's for the TechEvent presentation Oracle 18c New Security Features.

Demos are shown on an Oracle 18c Docker based database.

docker run --detach --name te2018_cmudb \
  --volume /data/docker/volumes/te2018_cmudb:/u01 \
  -e ORACLE_SID=TE18CMU \
  -p 2521:1521 -p 6500:5500 \
  --hostname te2018_cmudb.postgasse.org \
  --dns 192.168.56.70 \
  --dns-search postgasse.org \
  oracle/database:18.3.0.0
  • CMU Config und authentication
  • schema only accounts
  • Unified Audit Trail to SYSLOG
  • Export / Import Unified Audit Trail
  • Encrypting Sensitive Credential Data

Create the keytab file

ktpass.exe -princ oracle/te2018_cmudb.postgasse.org@POSTGASSE.ORG \
  -mapuser te2018_cmudb.postgasse.org -pass manager -crypto ALL \
  -ptype KRB5_NT_PRINCIPAL -out C:\u00\app\oracle\network\te2018_cmudb.keytab
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment