Installation guide

7. mxODBC Cursor Objects
Column Name Column Comment
Datatype
TABLE_TYPE VARCHAR(128) Identifies the type given by the name in the TABLE_NAME
column. It can have the string values "TABLE", "VIEW",
"INOPERATIVE VIEW", "SYSTEM TABLE", "ALIAS", or
"SYNONYM".
REMARKS VARCHAR(254) Contains the descriptive information about the table.
.tableprivileges(qualifier=None, owner=None, table=None)
Query the data source for information on table privileges associated with
database tables.
The method is useful for determining and extracting table access permissions
from the database.
The catalog method generates a result set having the following schema:
Column Name Column Datatype Comment
TABLE_CAT VARCHAR(128) Always NULL.
TABLE_SCHEMA VARCHAR(128) The name of the schema containing TABLE_NAME.
TABLE_NAME VARCHAR(128) not
NULL
The name of the table, or view, or alias, or synonym.
GRANTOR VARCHAR(128) Authorization ID of the user who granted the
privilege.
GRANTEE VARCHAR(128) Authorization ID of the user to whom the privilege is
granted.
PRIVILEGE VARCHAR(128) The table privilege. This may be one of the following
strings: "ALTER", "CONTROL", "INDEX", "DELETE",
"INSERT", "REFERENCES", "SELECT", "UPDATE".
IS_GRANTABLE VARCHAR(3) Indicates whether the grantee is permitted to grant
the privilege to other users. This can be "YES", "NO"
or NULL.
133