DB2-学习笔记(2)-常用命令整理

1:数据库连接

a):用当前用户进行连接 CONNECT TO ERMSYY

b):切换用户进行数据库连接 CONNECT TO ERMSYY USER db2admin USING db2admin

2：查看当前用户模式

SELECT CURRENT SCHEMA FROM SYSIBM.SYSDUMMY1

SELECT CURRENT SCHEMA FROM SYSIBM.DUAL

3：切换用户模式

set current schema XXXX

5：查看当前用户权限

GET AUTHORIZATIONS

直接 SYSADM 权限                           = NO
 直接 SYSCTRL 权限                          = NO
 直接 SYSMAINT 权限                         = NO
 直接 DBADM 权限                            = NO
 直接 CREATETAB 权限                        = NO
 直接 BINDADD 权限                          = NO
 直接 CONNECT 权限                          = NO
 直接 CREATE_NOT_FENC 权限                  = NO
 直接 IMPLICIT_SCHEMA 权限                  = NO
 直接 LOAD 权限                             = NO
 直接 QUIESCE_CONNECT 权限                  = NO
 直接 CREATE_EXTERNAL_ROUTINE 权限          = NO
 直接 SYSMON 权限                           = NO

 间接 SYSADM 权限                           = YES
 间接 SYSCTRL 权限                          = NO
 间接 SYSMAINT 权限                         = NO
 间接 DBADM 权限                            = NO
 间接 CREATETAB 权限                        = YES
 间接 BINDADD 权限                          = YES
 间接 CONNECT 权限                          = YES
 间接 CREATE_NOT_FENC 权限                  = NO
 间接 IMPLICIT_SCHEMA 权限                  = YES
 间接 LOAD 权限                             = NO
 间接 QUIESCE_CONNECT 权限                  = NO
 间接 CREATE_EXTERNAL_ROUTINE 权限          = NO
 间接 SYSMON 权限                           = NO