***権限管理 [#ndc6f1c5]
-PUBLICの取り扱い
db2 => connect to report
Database Connection Information
Database server = DB2/LINUX 8.2.9
SQL authorization ID = DB2INST1
Local database alias = REPORT
db2 => select char( GRANTEE, 24 ) as GRANTEE, GRANTEETYPE, char(SCHEMANAME, 24 ) as SCHEMANAME, CREATEINAUTH from SYSCAT.SCHEMAAUTH
GRANTEE GRANTEETYPE SCHEMANAME CREATEINAUTH
------------------------ ----------- ------------------------ ------------
PUBLIC G NULLID Y
PUBLIC G SQLJ Y
PUBLIC G DB2INST1 Y
PUBLIC G SYSTOOLS Y
4 record(s) selected.
