$sql.metaData.getTablePrivileges

Retrieves a description of the access rights for each table available in a catalog.

Syntax	$sql.metaData.getTablePrivileges{jdbcProfileName}{String catalog}{String schemaPattern}{String tableNamePattern}
Documentation	Retrieves a description of the access rights for each table available in a catalog. Note that a table privilege applies to one or more columns in the table. It would be wrong to assume that this privilege applies to all columns (this may be true for some systems but is not true for all.) Only privileges matching the schema and table name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME, and PRIVILEGE. Each privilige description has the following columns: TABLE_CAT String => table catalog (may be null) TABLE_SCHEM String => table schema (may be null) TABLE_NAME String => table name GRANTOR => grantor of access (may be null) GRANTEE String => grantee of access PRIVILEGE String => name of access (SELECT, INSERT, UPDATE, REFRENCES, ...) IS_GRANTABLE String => "YES" if grantee is permitted to grant to others; "NO" if not; null if unknown : Paramter: catalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search schemaPattern - a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search tableNamePattern - a table name pattern; must match the table name as it is stored in the database Returns: ResultSet - each row is a table privilege description Throws: SQLException - if a database access error occurs
Examples

Group	SQL
Minimum required transaction-mode:	NONE
Required scripting permission of the developer	PERMISSION_FL_BASIC
Minimum parameters	4
Maximum parameters	4