Installation guide

mxODBC - Python ODBC Database Interface
Column Name Column Datatype Comment
otherwise.
.columnprivileges(qualifier=None, owner=None, table=None,
column=None)
Query the database schema for information on column privileges for the given
table. This is useful to determine the authorizations granted to a table or
column.
column allows restricting the results to a single column of a table.
Note that the
table parameter is mandatory.
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.
COLUMN_NAME VARCHAR(128) not
NULL
Name of the column of the specified table, view,
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: "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.
118