Export (0) Print
Expand All

TABLE_PRIVILEGES

SQL Server 2000

Contains one row for each table privilege granted to or by the current user in the current database. The INFORMATION_SCHEMA.TABLE_PRIVILEGES view is based on the sysprotects and sysobjects system tables.

To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA view_name.

Column name Data type Description
GRANTOR nvarchar(128) Privilege grantor.
GRANTEE nvarchar(128) Privilege grantee.
TABLE_CATALOG nvarchar(128) Table qualifier.
TABLE_SCHEMA nvarchar(128) Table owner.
TABLE_NAME sysname Table name.
PRIVILEGE_TYPE varchar(10) Type of privilege.
IS_GRANTABLE varchar(3) Specifies whether the grantee has the ability to grant permissions to others.

See Also

sysobjects

sysprotects

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft