sp_table_privileges

Description

Returns privilege information for all columns in a table or view.

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]]

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: 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.

Usage

This procedure corresponds to the ODBC function SQLTablePrivileges.