sp_table_privileges

Returns privilege information for all 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_table_privileges table_name [, table_owner
[, table_qualifier]]

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 – For DB2 UDB targets, this is ignored. Leave blank or set to NULL.
For non DB2 targets, this is the name of the database. Acceptable values are the current database or NULL.

This procedure corresponds to the ODBC function SQLTablePrivileges.