Returns one row for each table privilege that is granted to or granted by the current user in the current database.
To retrieve information from these views, specify the fully qualified name of INFORMATION_SCHEMA.view_name.
GRANTOR
nvarchar(128)
Privilege grantor.
GRANTEE
Privilege grantee.
TABLE_CATALOG
Table qualifier.
TABLE_SCHEMA
Name of schema that contains the table.
TABLE_NAME
sysname
Table name.
PRIVILEGE_TYPE
varchar(10)
Type of privilege.
IS_GRANTABLE
varchar(3)
Specifies whether the grantee can grant permissions to others.
The following example returns returns rows from the TABLE_PRIVILEGES view.
TABLE_PRIVILEGES
USE AdventureWorks; GO SELECT * FROM INFORMATION_SCHEMA.TABLE_PRIVILEGES;