com.aspc.commander.sql

Class TablePrivilegesCommand

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.commander.sql.TablePrivilegesCommand

All Implemented Interfaces:

CommandBuildResultsPlugin

public class TablePrivilegesCommand
extends SQLCommand

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 privilege description has the following columns:

TABLE_CAT</B> String => table catalog (may be <code>null</code>)
TABLE_SCHEM</B> String => table schema (may be <code>null</code>)
TABLE_NAME</B> String => table name
GRANTOR</B> => grantor of access (may be <code>null</code>)
GRANTEE</B> String => grantee of access
PRIVILEGE</B> String => name of access (SELECT, INSERT, UPDATE, REFRENCES, ...)
IS_GRANTABLE</B> String => "YES" if grantee is permitted to grant to others; "NO" if not; <code>null</code> if unknown

catalog_name 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

schema_pattern 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

table_pattern a table name pattern; must match the table name as it is stored in the database
Syntax

  TABLE_PRIVILEGES CATALOG catalog_name SCHEMA schema_pattern TABLE table_pattern
  

THREAD MODE: SINGLE THREADED command

Since:

3 December 2003

Author:

Nigel Leck

Field Summary

Fields inherited from class com.aspc.commander.sql.SQLCommand

CURSOR_SIZE

Constructor Summary

Constructors

Constructor and Description
TablePrivilegesCommand(Connection connection, Pattern pattern) std.

Method Summary

Modifier and Type	Method and Description
protected void	execute(Parser p) execute the command.
java.lang.String	getColumnName(int col) the column name
java.lang.String	getColumnType(int col) Gets the column type for the given column index, starting at one
java.lang.String	getRecordID(int row) the record ID
java.lang.Object	getValue(int row, int col) the value for this row, column

Methods inherited from class com.aspc.commander.sql.SQLCommand

appendResult, appendResult, getCursorName, getRecordKey, isExecuteOnly

Methods inherited from class com.aspc.commander.Command

execute, extMakeThreadName, getConnection, getPattern, getRawTitle, getTitle, makeThreadName, recordCall, setTitle

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.aspc.commander.sql.results.CommandBuildResultsPlugin

getRawTitle

Constructor Detail

TablePrivilegesCommand

public TablePrivilegesCommand(Connection connection,
                              Pattern pattern)

std. Command.

Parameters:

connection - the connection

pattern - the pattern

Method Detail

execute

protected void execute(Parser p)
                throws java.lang.Exception

execute the command.

Specified by:

execute in class Command

Parameters:

p - The parser

Throws:

java.lang.Exception - A serious problem

getColumnName

public java.lang.String getColumnName(int col)

the column name

Parameters:

col - the column

Returns:

the name

getColumnType

public java.lang.String getColumnType(int col)

Gets the column type for the given column index, starting at one

Parameters:

col - the column index

Returns:

String the column type

getRecordID

public java.lang.String getRecordID(int row)

the record ID

Parameters:

row - the row index

Returns:

the record ID

getValue

public java.lang.Object getValue(int row,
                                 int col)
                          throws java.lang.Exception

the value for this row, column

Parameters:

row - the row index

col - the column

Returns:

Object the value for the given row and column

Throws:

java.lang.Exception - Exception A serious problem