db2_privileges[@more@]

CONNECT TO DB2LOG;
GRANT DBADM,CREATETAB,BINDADD,CONNECT,CREATE_NOT_FENCED_ROUTINE,IMPLICIT_SCHEMA,LOAD,CREATE_EXTERNAL_ROUTINE,QUIESCE_CONNECT ON DATABASE TO USER DB2DB;
GRANT CREATEIN,DROPIN,ALTERIN ON SCHEMA DB2T TO USER DB2DB WITH GRANT OPTION;
CONNECT RESET;

CONNECT TO DB2LOG;
CREATE SCHEMA DB2DB AUTHORIZATION DB2DB;
CONNECT RESET;

CONNECT TO DB2LOG;
GRANT CREATETAB,CONNECT ON DATABASE TO USER DB2DB;
CONNECT RESET;

CONNECT TO DB2LOG;
GRANT CONTROL ON TABLE DB2DB.TEST TO USER DB2DB;
GRANT SELECT,INSERT,UPDATE,DELETE,ALTER,INDEX,REFERENCES ON TABLE DB2DB.TEST TO USER DB2DB WITH GRANT OPTION;
CONNECT RESET;