SAP DB:ODBC Guide d'installation télécharger pdf (Page 140)

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

1 2 ... 135 136 137 138 139 140 141 142 143 144 145 ... 224 225

Pas de commentaire

SAP DB:ODBC Guide d'installation Page 140