Returns column privilege information for one or more columns
in a table or view.
Note: This stored procedure is not supported in ECDA Option
for ODBC to DB2 UDB data sources.
Syntax
sp_column_privileges table_name [, table_owner
[, table_qualifier [, column_name]]]
Parameters
- table_name – is the name of the table. Wildcard-character search
patterns are not supported.
- table_owner – is the name of the table owner. Wildcard-character
search patterns are not supported.
- table_qualifier – is ignored. Leave blank or
set to NULL.
- column_name – is the name of the column for which you want privilege information. Use wildcard-character search
patterns to request information about more than
one column. Leave blank or set to
NULL to request information about
all columns in the table or tables.
Usage
This procedure corresponds to the ODBC function called SQLColumnPrivileges.