• Home
• com.sqlapp
• sqlapp-core-derby
• 0.8.4
• source code
• columnPrivileges.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.

com.sqlapp.data.db.dialect.derby.metadata.columnPrivileges.sql Maven / Gradle / Ivy

SELECT cp.*
, t.TABLENAME AS table_name
, S.SCHEMANAME AS schema_name
FROM SYS.SYSCOLPERMS cp
INNER JOIN SYS.SYSTABLES t
  ON (cp.TABLEID=t.TABLEID)
INNER JOIN SYS.SYSSCHEMAS s
  ON (t.SCHEMAID=s.SCHEMAID)
WHERE 1=1 
  /*if isNotEmpty(schemaName)*/
  AND s.SCHEMANAME IN /*schemaName*/('%')
  /*end*/
  /*if isNotEmpty(tableName)*/
  AND t.TABLENAME IN /*tableName*/('%')
  /*end*/
ORDER BY cp.GRANTOR, cp.GRANTEE, s.SCHEMANAME, t.TABLENAME