sp_table_privileges

Description

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

Syntax

sp_table_privileges table_name [, table_owner[, table_qualifier]]

Parameters

table_name

is the name of the table. The use of wildcard characters in pattern matching is not supported.

table_owner

is the name of the table owner. The use of wildcard characters in pattern matching is not supported. If you do not specify the table owner, sp_table_privileges looks for a table owned by the current user and then for a table owned by the Database Owner.

table_qualifier

is the name of the database. This can be either the current database or NULL.

Usage

Permissions

Any user can execute sp_table_privileges.