目的：
测试DB2安全，本脚本摘录自DB2安装目录admin_scripts/security.db2。
版本：Windows DB2 Express-C V9.7
操作步骤：
使用"db2cmd db2 -t"进入交互模式,执行后续操作。
-- Connect to sample database
CONNECT TO SAMPLE;
-- Retrieve the group to which the user belongs to
SELECT * FROM table (SYSPROC.AUTH_LIST_GROUPS_FOR_AUTHID (CURRENT USER)) AS ST;
--操作系统中用户所属组
-- Retrieve the objects owned by the current user
SELECT * FROM SYSIBMADM.OBJECTOWNERS WHERE WNER = CURRENT USER;
-- Retrieve authorities/privileges directly granted to the user
SELECT * FROM SYSIBMADM.PRIVILEGES WHERE AUTHID = CURRENT USER;
-- Retrieve the authorization type of the authid
SELECT * FROM SYSIBMADM.AUTHORIZATIONIDS WHERE AUTHID = CURRENT USER;
-- Disconnect from the sample database;
CONNECT RESET;
TERMINATE;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/18922393/viewspace-702291/ ，如需转载，请注明出处，否则将追究法律责任。
