• Home
• us.fatehi
• schemacrawler-db2
• 16.24.2
• source code
• DATABASE_USERS.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db2.information_schema.DATABASE_USERS.sql Maven / Gradle / Ivy

SELECT
  AUTHID AS USERNAME,
  BINDADDAUTH,
  CONNECTAUTH,
  CREATETABAUTH,
  DBADMAUTH,
  EXTERNALROUTINEAUTH,
  IMPLSCHEMAAUTH,
  LOADAUTH,
  NOFENCEAUTH,
  QUIESCECONNECTAUTH,
  SECURITYADMAUTH,
  SQLADMAUTH,
  WLMADMAUTH,
  EXPLAINAUTH,
  DATAACCESSAUTH,
  ACCESSCTRLAUTH,
  CREATESECUREAUTH
FROM
  SYSIBMADM.AUTHORIZATIONIDS A
  LEFT JOIN SYSCAT.DBAUTH D
    ON D.GRANTEE = A.AUTHID
WHERE
  AUTHIDTYPE = 'U'
WITH UR