• Home
• us.fatehi
• schemacrawler-hsqldb
• 16.24.2
• source code
• TABLE_COLUMN_PRIVILEGES.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.

hsqldb.information_schema.TABLE_COLUMN_PRIVILEGES.sql Maven / Gradle / Ivy

SELECT
  TABLE_CATALOG AS TABLE_CAT,
  TABLE_SCHEMA AS TABLE_SCHEM,
  TABLE_NAME,
  COLUMN_NAME,
  GRANTOR,
  GRANTEE,
  PRIVILEGE_TYPE AS PRIVILEGE,
  IS_GRANTABLE
FROM
  INFORMATION_SCHEMA.COLUMN_PRIVILEGES
ORDER BY
  TABLE_CATALOG,
  TABLE_SCHEMA,
  TABLE_NAME,
  COLUMN_NAME,
  PRIVILEGE_TYPE,  
  GRANTOR,
  GRANTEE