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;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8806316/viewspace-1001421/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8806316/viewspace-1001421/