查詢目前資料庫哪些帳號
SELECT * FROM SYSIBM.SYSDBAUTH
GRANTOR |GRANTEE |DBADMAUTH|CREATETABAUTH|BINDADDAUTH|CONNECTAUTH|NOFENCEAUTH|GRANTEETYPE|IMPLSCHEMAAUTH|LOADAUTH|EXTERNALROUTINEAUTH|QUIESCECONNECTAUTH|SECURITYADMAUTH|LIBRARYADMAUTH|GRANTORTYPE|GRANTEEROLEID|GRANTORROLEID|SQLADMAUTH|WLMADMAUTH|EXPLAINAUTH|DATAACCESSAUTH|ACCESSCTRLAUTH|
-------+--------+---------+-------------+-----------+-----------+-----------+-----------+--------------+--------+-------------------+------------------+---------------+--------------+-----------+-------------+-------------+----------+----------+-----------+--------------+--------------+
SYSIBM |DB2INST1|Y |N |N |N |N |U |N |N |N |N |Y |N |S | | |N |N |N |Y |Y |
SYSIBM |PUBLIC |N |Y |Y |Y |N |G |Y |N |N |N |N |N |S | | |N |N |N |N |N |
DB2INST1|USER1 |Y |Y |Y |Y |Y |U |Y |Y |Y |Y |Y |N |U | | |Y |Y |N |Y |Y |
