DB2 security audit
Posted by: DBA DB2,
on 10 Jan 2012 |
View original | Bookmarked: 0 time(s)
The SYSIBM.SYSDBAUTH maintains user privileges on databases
The SYSIBM.SYSPLANAUTH maintains user privileges on plans
The SYSIBM.SYSUSERAUTH maintain user privileges on the system.
This shell script collects and records these recordsets. Useful for regular DB2 security audits.
working_dir=$PWD
logfile="AUTH_'date +%d%m%y'.log"
#export working_dir
#export logfile
touch $working_dir/$logfile
>$working_dir/$logfile
echo "Current working directory $working_dir" >>...