sp_column_privileges

Description

Returns column privilege information for one or more columns in a table or view.

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.