db2_privileges
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博客 ” ，链接：https://blog.itpub.net/8806316/viewspace-1001421/ ，如需转载，请注明出处，否则将追究法律责任。
最新文章
- oracle virtualbox修改虚拟机的default machine folder
- linux 脚本 for 与while实际中的区别
- linux下nc检测端口
- linux_命令行批量修改密码
- linux_vmware_openfiler_静默方式安装_ora10201_rac执行root.sh脚本报错libpthread.so.0不能打开处理
- linux_vsftpd登录后执行ls不显示文件列表
- linux_openfiler_udev配置
- rhel5.6_openfiler_oracle10gRAC_udev
- linux_ulimit_open filer
- linux下nc扫描tcp,udp端口
