[ 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

Logo

魔乐社区(Modelers.cn) 是一个中立、公益的人工智能社区,提供人工智能工具、模型、数据的托管、展示与应用协同服务,为人工智能开发及爱好者搭建开放的学习交流平台。社区通过理事会方式运作,由全产业链共同建设、共同运营、共同享有,推动国产AI生态繁荣发展。

更多推荐