Dbwho shell script

#!/bin/sh

# Program: dbwho Description: List database, user and workstation of all db users

echo "Generating list of users by database ..."

dbaccess sysmaster - <<EOF

select sysdatabases.name database,

syssessions.username,

syssessions.hostname,

syslocks.owner sid

from syslocks, sysdatabases , outer syssessions

where syslocks.rowidlk = sysdatabases.rowid

and syslocks.tabname = "sysdatabases"

and syslocks.owner = syssessions.sid

order by 1;

EOF

Previous slide

Next slide

Back to first slide

View graphic version