8.6.16 getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)

(1) Function

This method acquires information about table column access permissions.

To Page Top

(2) Format

public synchronized ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) throws SQLException

To Page Top

(3) Arguments

String catalog

Specifies a catalog name. This argument is ignored, if specified.

String schema

Specifies a schema name. This argument is ignored, if specified.

String table

Specifies a table name. This argument is ignored, if specified.

String columnNamePattern

Specifies a column name pattern. This argument is ignored, if specified.

To Page Top

(4) Return value

This method always returns a ResultSet object that contains no retrieval result rows. The following table shows the format of the ResultSet object that is returned.

Table 8‒47: Format of the ResultSet object that is returned (getColumnPrivileges method)

Column No.	Type	Column name	Description
1	String	TABLE_CAT	Catalog name
2	String	TABLE_SCHEM	Schema name
3	String	TABLE_NAME	Table name
4	String	COLUMN_NAME	Column name
5	String	GRANTOR	User who grants access privilege
6	String	GRANTEE	User who receives access privilege
7	String	PRIVILEGE	Name of access privilege
8	String	IS_GRANTABLE	Whether a user who has received an access privilege can grant access privileges to other HADB users

To Page Top

(5) Exceptions

If this Connection object is closed before this method is executed, the JDBC driver throws an SQLException.

To Page Top