db2 - 查看当前用户的权限

[ db2inst1@db ~]$ db2 connect to py user db2inst1 using  admin@123

   Database Connection Information

 Database server        = DB2/LINUXX8664 9.7.0

 SQL authorization ID   = DB2INST1

 Local database alias   = PY

[ db2inst1@db ~]$ db2 get authorizations

 Administrative Authorizations for Current User

 Direct SYSADM authority                    = NO

 Direct SYSCTRL authority                   = NO

 Direct SYSMAINT authority                  = NO

 Direct DBADM authority                     = YES

 Direct CREATETAB authority                 = NO

 Direct BINDADD authority                   = NO

 Direct CONNECT authority                   = NO

 Direct CREATE_NOT_FENC authority           = NO

 Direct IMPLICIT_SCHEMA authority           = NO

 Direct LOAD authority                      = NO

 Direct QUIESCE_CONNECT authority           = NO

 Direct CREATE_EXTERNAL_ROUTINE authority   = NO

 Direct SYSMON authority                    = NO

 Indirect SYSADM authority                  = YES

 Indirect SYSCTRL authority                 = NO

 Indirect SYSMAINT authority                = NO

 Indirect DBADM authority                   = NO

 Indirect CREATETAB authority               = YES

 Indirect BINDADD authority                 = YES

 Indirect CONNECT authority                 = YES

 Indirect CREATE_NOT_FENC authority         = NO

 Indirect IMPLICIT_SCHEMA authority         = YES

 Indirect LOAD authority                    = NO

 Indirect QUIESCE_CONNECT authority         = NO

 Indirect CREATE_EXTERNAL_ROUTINE authority = NO

 Indirect SYSMON authority                  = NO

[ db2inst1@db ~]$ db2 connect to py user oracle using oracle

   Database Connection Information

 Database server        = DB2/LINUXX8664 9.7.0

 SQL authorization ID   = ORACLE

 Local database alias   = PY

[ db2inst1@db ~]$ db2 get authorizations

 Administrative Authorizations for Current User

 Direct SYSADM authority                    = NO

 Direct SYSCTRL authority                   = NO

 Direct SYSMAINT authority                  = NO

 Direct DBADM authority                     = NO

 Direct CREATETAB authority                 = NO

 Direct BINDADD authority                   = NO

 Direct CONNECT authority                   = NO

 Direct CREATE_NOT_FENC authority           = NO

 Direct IMPLICIT_SCHEMA authority           = NO

 Direct LOAD authority                      = NO

 Direct QUIESCE_CONNECT authority           = NO

 Direct CREATE_EXTERNAL_ROUTINE authority   = NO

 Direct SYSMON authority                    = NO

 Indirect SYSADM authority                  = NO

 Indirect SYSCTRL authority                 = NO

 Indirect SYSMAINT authority                = NO

 Indirect DBADM authority                   = NO

 Indirect CREATETAB authority               = YES

 Indirect BINDADD authority                 = YES

 Indirect CONNECT authority                 = YES

 Indirect CREATE_NOT_FENC authority         = NO

 Indirect IMPLICIT_SCHEMA authority         = YES

 Indirect LOAD authority                    = NO

 Indirect QUIESCE_CONNECT authority         = NO

 Indirect CREATE_EXTERNAL_ROUTINE authority = NO

 Indirect SYSMON authority                  = NO