linux查看db2所有用户,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