sp_stored_procedures  sp_tables

Chapter 11: Accessing Catalog Information with CSPs

sp_table_privileges

Description

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

NoteThis stored procedure is not supported in either DirectConnect for DB2 UDB.

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 – is ignored. Leave blank or set to NULL.

For non-DB2 targets – is the name of the database. Acceptable values are the current database or NULL.

Usage

This procedure corresponds to the ODBC function SQLTablePrivileges.





Copyright © 2005. Sybase Inc. All rights reserved. sp_tables

View this book as PDF